Overview

Dataset info

Number of variables181
Number of observations566
Missing cells35172 (34.3%)
Duplicate rows0 (0.0%)
Total size in memory762.9 KiB
Average record size in memory1.3 KiB

Variables types

Numeric69
Categorical20
Boolean15
Date0
URL0
Text (Unique)1
Rejected76
Unsupported0

Warnings

coligada_mais_antiga_ativa has 267 (47.2%) missing values Missing
coligada_mais_antiga_baixada has constant value "nan" Rejected
coligada_mais_nova_ativa has 267 (47.2%) missing values Missing
coligada_mais_nova_baixada has constant value "nan" Rejected
de_indicador_telefone has constant value "BOA" Rejected
de_saude_rescencia has constant value "ACIMA DE 1 ANO" Rejected
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 207 distinct values Warning
empsetorcensitariofaixarendapopulacao has 70 (12.4%) missing values Missing
faturamento_est_coligados has 273 (48.2%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.96717) Rejected
fl_epp has constant value "False" Rejected
fl_matriz has constant value "True" Rejected
fl_mei has constant value "False" Rejected
fl_optante_simei has constant value "False" Rejected
grau_instrucao_macro_analfabeto has 449 (79.3%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental has 48 (8.5%) missing values Missing
grau_instrucao_macro_escolaridade_superior has 17 (3.0%) missing values Missing
idade_acima_de_58 has 61 (10.8%) missing values Missing
idade_ate_18 has 351 (62.0%) missing values Missing
idade_de_19_a_23 has 94 (16.6%) missing values Missing
idade_de_24_a_28 has 17 (3.0%) missing values Missing
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.95905) Rejected
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.98342) Rejected
idade_de_49_a_53 is highly correlated with idade_de_44_a_48 (ρ = 0.99027) Rejected
idade_de_54_a_58 is highly correlated with idade_de_49_a_53 (ρ = 0.98514) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.99911) Rejected
idade_maxima_socios has 213 (37.6%) missing values Missing
idade_media_coligadas has 267 (47.2%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.9995) Rejected
idade_media_coligadas_baixadas has constant value "nan" Rejected
idade_media_socios has 213 (37.6%) missing values Missing
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 0.99963) Rejected
idade_minima_socios has 213 (37.6%) missing values Missing
max_faturamento_est_coligados has 273 (48.2%) missing values Missing
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.94873) Rejected
max_filiais_coligados is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.92095) Rejected
max_funcionarios_coligados_gp is highly correlated with max_filiais_coligados (ρ = 0.95968) Rejected
max_vl_folha_coligados has 332 (58.7%) missing values Missing
max_vl_folha_coligados_gp is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.9326) Rejected
media_faturamento_est_coligados has 273 (48.2%) missing values Missing
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.97553) Rejected
media_filiais_coligados is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.93788) Rejected
media_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.97637) Rejected
media_vl_folha_coligados has 332 (58.7%) missing values Missing
media_vl_folha_coligados_gp is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.93982) Rejected
min_faturamento_est_coligados has 273 (48.2%) missing values Missing
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.94763) Rejected
min_filiais_coligados has 413 (73.0%) missing values Missing
min_funcionarios_coligados_gp has 93 (16.4%) zeros Zeros
min_funcionarios_coligados_gp has 314 (55.5%) missing values Missing
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.98348) Rejected
min_meses_servicos_all has 35 (6.2%) zeros Zeros
min_vl_folha_coligados is highly correlated with media_vl_folha_coligados (ρ = 0.92717) Rejected
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.95645) Rejected
nm_divisao has a high cardinality: 60 distinct values Warning
nm_meso_regiao has 70 (12.4%) missing values Missing
nm_micro_regiao has a high cardinality: 61 distinct values Warning
nm_micro_regiao has 70 (12.4%) missing values Missing
qt_admitidos_12meses has 199 (35.2%) zeros Zeros
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art has 304 (53.7%) missing values Missing
qt_coligadas has 267 (47.2%) missing values Missing
qt_coligados is highly correlated with qt_coligadas (ρ = 1) Rejected
qt_coligados_agropecuaria has 265 (46.8%) zeros Zeros
qt_coligados_agropecuaria has 267 (47.2%) missing values Missing
qt_coligados_atividade_alto has constant value "0.0" Rejected
qt_coligados_atividade_baixo has constant value "0.0" Rejected
qt_coligados_atividade_inativo has constant value "0.0" Rejected
qt_coligados_atividade_medio has constant value "0.0" Rejected
qt_coligados_atividade_mt_baixo has constant value "0.0" Rejected
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.99984) Rejected
qt_coligados_baixada has 267 (47.2%) missing values Missing
qt_coligados_ccivil has 220 (38.9%) zeros Zeros
qt_coligados_ccivil has 267 (47.2%) missing values Missing
qt_coligados_centro has 272 (48.1%) zeros Zeros
qt_coligados_centro has 267 (47.2%) missing values Missing
qt_coligados_comercio has 152 (26.9%) zeros Zeros
qt_coligados_comercio has 267 (47.2%) missing values Missing
qt_coligados_epp has constant value "0.0" Rejected
qt_coligados_exterior has 267 (47.2%) missing values Missing
qt_coligados_inapta has 267 (47.2%) missing values Missing
qt_coligados_industria has 211 (37.3%) zeros Zeros
qt_coligados_industria has 267 (47.2%) missing values Missing
qt_coligados_ltda has 286 (50.5%) zeros Zeros
qt_coligados_ltda has 267 (47.2%) missing values Missing
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.99904) Rejected
qt_coligados_me has constant value "0.0" Rejected
qt_coligados_mei has 267 (47.2%) missing values Missing
qt_coligados_nordeste has 141 (24.9%) zeros Zeros
qt_coligados_nordeste has 267 (47.2%) missing values Missing
qt_coligados_norte has 159 (28.1%) zeros Zeros
qt_coligados_norte has 267 (47.2%) missing values Missing
qt_coligados_nula has constant value "0.0" Rejected
qt_coligados_sa is highly correlated with qt_coligados_industria (ρ = 0.92957) Rejected
qt_coligados_serviço has 61 (10.8%) zeros Zeros
qt_coligados_serviço has 267 (47.2%) missing values Missing
qt_coligados_sudeste is highly correlated with qt_coligados_matriz (ρ = 0.92867) Rejected
qt_coligados_sul has 287 (50.7%) zeros Zeros
qt_coligados_sul has 267 (47.2%) missing values Missing
qt_coligados_suspensa has constant value "0.0" Rejected
qt_desligados_12meses has 187 (33.0%) zeros Zeros
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 1) Rejected
qt_filiais has 270 (47.7%) zeros Zeros
qt_funcionarios is highly correlated with idade_de_54_a_58 (ρ = 0.94732) Rejected
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.99761) Rejected
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.98334) Rejected
qt_funcionarios_coligados has 18 (3.2%) zeros Zeros
qt_funcionarios_coligados has 314 (55.5%) missing values Missing
qt_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.90605) Rejected
qt_funcionarios_grupo is highly skewed (γ1 = 21.811) Skewed
qt_ramos_coligados has 267 (47.2%) missing values Missing
qt_regioes_coligados has 267 (47.2%) missing values Missing
qt_socios has 184 (32.5%) missing values Missing
qt_socios_coligados is highly correlated with qt_coligados_matriz (ρ = 0.96791) Rejected
qt_socios_feminino is highly correlated with qt_socios (ρ = 0.98778) Rejected
qt_socios_masculino is highly correlated with qt_socios_feminino (ρ = 0.96613) Rejected
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.97676) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.9745) Rejected
qt_socios_pj has 184 (32.5%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 0.96283) Rejected
qt_socios_pj_baixados has 515 (91.0%) missing values Missing
qt_socios_pj_inaptos has constant value "0.0" Rejected
qt_socios_pj_nulos has constant value "0.0" Rejected
qt_socios_pj_suspensos has constant value "0.0" Rejected
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.99433) Rejected
qt_socios_st_suspensa has constant value "nan" Rejected
qt_ufs_coligados has 267 (47.2%) missing values Missing
sum_faturamento_estimado_coligadas is highly correlated with faturamento_est_coligados_gp (ρ = 0.96717) Rejected
total is highly correlated with qt_funcionarios_24meses (ρ = 0.97843) Rejected
total_filiais_coligados is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.92158) Rejected
tx_crescimento_12meses has 195 (34.5%) zeros Zeros
tx_crescimento_24meses is highly correlated with qt_socios_pep (ρ = 0.96385) Rejected
tx_rotatividade has 188 (33.2%) zeros Zeros
vl_folha_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.92165) Rejected
vl_folha_coligados_gp is highly correlated with max_vl_folha_coligados_gp (ρ = 0.90572) Rejected
vl_frota has 98 (17.3%) missing values Missing
vl_idade_maxima_socios_pj has 515 (91.0%) missing values Missing
vl_idade_media_socios_pj is highly correlated with vl_idade_maxima_socios_pj (ρ = 0.93323) Rejected
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 0.92519) Rejected
vl_potenc_cons_oleo_gas has 472 (83.4%) missing values Missing
vl_total_tancagem is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.94313) Rejected
vl_total_tancagem_grupo has 536 (94.7%) missing values Missing
vl_total_veiculos_antt is highly correlated with vl_total_tancagem_grupo (ρ = 0.9644) Rejected
vl_total_veiculos_antt_grupo is highly correlated with vl_total_veiculos_antt (ρ = 1) Rejected
vl_total_veiculos_leves has 47 (8.3%) zeros Zeros
vl_total_veiculos_leves has 76 (13.4%) missing values Missing
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_leves (ρ = 0.95902) Rejected
vl_total_veiculos_pesados has 165 (29.2%) zeros Zeros
vl_total_veiculos_pesados has 76 (13.4%) missing values Missing
vl_total_veiculos_pesados_grupo has 237 (41.9%) zeros Zeros

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count292
Unique (%)51.6%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean299.87
Minimum2.7667
Maximum1135.2
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.7667
5-th percentile35.37
Q1151.27
Median275.47
Q3432.65
95-th percentile630.89
Maximum1135.2
Range1132.5
Interquartile range281.38

Descriptive statistics

Standard deviation187.5
Coef of variation0.62528
Kurtosis0.16843
Mean299.87
MAD153.49
Skewness0.55723
Sum89661
Variance35156
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
500.13 2 0.4%
 
101.83 2 0.4%
 
635.23 2 0.4%
 
438.73 2 0.4%
 
657.87 2 0.4%
 
261.03 2 0.4%
 
186.8 2 0.4%
 
634.5 2 0.4%
 
336.43 1 0.2%
 
361.73 1 0.2%
 
Other values (281) 281 49.6%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2.7667 1 0.2%
 
5.8 1 0.2%
 
8.9333 1 0.2%
 
11.133 1 0.2%
 
17.133 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1135.2 1 0.2%
 
674.93 1 0.2%
 
657.87 2 0.4%
 
642.67 1 0.2%
 
636.83 1 0.2%
 

coligada_mais_antiga_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

coligada_mais_nova_ativa
Numeric

Distinct count282
Unique (%)49.8%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean86.911
Minimum1.5
Maximum614
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.5
5-th percentile3.19
Q121.367
Median56.2
Q3116.25
95-th percentile287.9
Maximum614
Range612.5
Interquartile range94.883

Descriptive statistics

Standard deviation91.556
Coef of variation1.0534
Kurtosis4.7987
Mean86.911
MAD66.987
Skewness1.9204
Sum25986
Variance8382.6
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
56.9 2 0.4%
 
14.567 2 0.4%
 
2.0333 2 0.4%
 
2.7667 2 0.4%
 
237.43 2 0.4%
 
4.8 2 0.4%
 
186.8 2 0.4%
 
47.8 2 0.4%
 
9.4667 2 0.4%
 
17.933 2 0.4%
 
Other values (271) 279 49.3%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1.5 2 0.4%
 
1.6 1 0.2%
 
1.9667 1 0.2%
 
2.0333 2 0.4%
 
2.4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
614 1 0.2%
 
424.63 1 0.2%
 
378.13 1 0.2%
 
377.9 1 0.2%
 
368.87 1 0.2%
 

coligada_mais_nova_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

de_faixa_faturamento_estimado
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
DE R$ 10.000.000,01 A R$ 30.000.000,00
278
DE R$ 30.000.000,01 A R$ 100.000.000,00
202
DE R$ 100.000.000,01 A R$ 300.000.000,00
58
Other values (3)
 
28
ValueCountFrequency (%) 
DE R$ 10.000.000,01 A R$ 30.000.000,00 278 49.1%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 202 35.7%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 58 10.2%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 15 2.7%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 8 1.4%
 
ACIMA DE 1 BILHAO DE REAIS 5 0.9%
 
Max length40
Mean length38.537
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
DE R$ 10.000.000,01 A R$ 30.000.000,00
247
DE R$ 30.000.000,01 A R$ 100.000.000,00
210
DE R$ 100.000.000,01 A R$ 300.000.000,00
78
Other values (3)
 
31
ValueCountFrequency (%) 
DE R$ 10.000.000,01 A R$ 30.000.000,00 247 43.6%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 210 37.1%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 78 13.8%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 14 2.5%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 9 1.6%
 
ACIMA DE 1 BILHAO DE REAIS 8 1.4%
 
Max length40
Mean length38.558
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Constant

This variable is constant and should be ignored for analysis

Constant valueBOA

de_natureza_juridica
Categorical

Distinct count26
Unique (%)4.6%
Missing (%)0.0%
Missing (n)0
SOCIEDADE EMPRESARIA LIMITADA
287
MUNICIPIO
110
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA
 
31
Other values (23)
138
ValueCountFrequency (%) 
SOCIEDADE EMPRESARIA LIMITADA 287 50.7%
 
MUNICIPIO 110 19.4%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 31 5.5%
 
ASSOCIACAO PRIVADA 21 3.7%
 
SOCIEDADE ANONIMA FECHADA 21 3.7%
 
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL 19 3.4%
 
ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL 12 2.1%
 
EMPRESARIO INDIVIDUAL 10 1.8%
 
SOCIEDADE SIMPLES LIMITADA 6 1.1%
 
FUNDO PUBLICO 6 1.1%
 
Other values (16) 43 7.6%
 
Max length70
Mean length27.896
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count3
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
ALTA
523
MEDIA
 
37
BAIXA
 
6
ValueCountFrequency (%) 
ALTA 523 92.4%
 
MEDIA 37 6.5%
 
BAIXA 6 1.1%
 
Max length5
Mean length4.076
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_ramo
Categorical

Distinct count29
Unique (%)5.1%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL
163
INDUSTRIA DA CONSTRUCAO
 
46
COMERCIO VAREJISTA
 
46
Other values (26)
311
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL 163 28.8%
 
INDUSTRIA DA CONSTRUCAO 46 8.1%
 
COMERCIO VAREJISTA 46 8.1%
 
SERVICOS ADMINISTRATIVOS 42 7.4%
 
COMERCIO POR ATACADO 40 7.1%
 
SERVICOS DE EDUCACAO 33 5.8%
 
QUIMICA-PETROQUIMICA 27 4.8%
 
SERVICOS DE SAUDE 25 4.4%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 25 4.4%
 
COMERCIO E REPARACAO DE VEICULOS 21 3.7%
 
Other values (19) 98 17.3%
 
Max length49
Mean length30.048
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Constant

This variable is constant and should be ignored for analysis

Constant valueACIMA DE 1 ANO

de_saude_tributaria
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)0.0%
Missing (n)0
VERDE
376
AZUL
134
LARANJA
 
44
Other values (2)
 
12
ValueCountFrequency (%) 
VERDE 376 66.4%
 
AZUL 134 23.7%
 
LARANJA 44 7.8%
 
VERMELHO 11 1.9%
 
AMARELO 1 0.2%
 
Max length8
Mean length4.9806
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count207
Unique (%)36.6%
Missing (%)0.0%
Missing (n)0
2005-11-03
201
2005-08-27
 
36
2005-09-24
 
32
Other values (204)
297
ValueCountFrequency (%) 
2005-11-03 201 35.5%
 
2005-08-27 36 6.4%
 
2005-09-24 32 5.7%
 
1998-07-28 17 3.0%
 
2005-10-07 8 1.4%
 
2005-10-14 6 1.1%
 
2004-12-24 5 0.9%
 
2004-12-31 5 0.9%
 
1999-02-27 4 0.7%
 
2005-10-22 4 0.7%
 
Other values (197) 248 43.8%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count439
Unique (%)77.6%
Missing (%)12.4%
Missing (n)70
Infinite (%)0.0%
Infinite (n)0
Mean1722.2
Minimum262.9
Maximum8467.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum262.9
5-th percentile503.25
Q1818.41
Median1215.2
Q32257.7
95-th percentile4802.2
Maximum8467.1
Range8204.2
Interquartile range1439.2

Descriptive statistics

Standard deviation1349.3
Coef of variation0.78347
Kurtosis3.9356
Mean1722.2
MAD998.78
Skewness1.869
Sum8.5421e+05
Variance1.8206e+06
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1157 10 1.8%
 
2799.8 4 0.7%
 
2286.1 3 0.5%
 
984.57 3 0.5%
 
3321.9 3 0.5%
 
2317.1 3 0.5%
 
1333.1 3 0.5%
 
1723.2 3 0.5%
 
5054.1 3 0.5%
 
2679.5 2 0.4%
 
Other values (428) 459 81.1%
 
(Missing) 70 12.4%
 

Minimum 5 values

ValueCountFrequency (%) 
262.9 1 0.2%
 
297.41 1 0.2%
 
304.77 1 0.2%
 
340.39 1 0.2%
 
346.02 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8467.1 2 0.4%
 
6721.6 1 0.2%
 
6583.6 1 0.2%
 
6527.2 1 0.2%
 
6498.2 1 0.2%
 

faturamento_est_coligados
Numeric

Distinct count239
Unique (%)42.2%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean1.9549e+08
Minimum1.2364e+05
Maximum7.7807e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.2364e+05
5-th percentile2.1e+05
Q19.3e+05
Median7.4801e+06
Q34.5219e+07
95-th percentile4.8541e+08
Maximum7.7807e+09
Range7.7806e+09
Interquartile range4.4289e+07

Descriptive statistics

Standard deviation8.8832e+08
Coef of variation4.5441
Kurtosis45.406
Mean1.9549e+08
MAD3.1206e+08
Skewness6.5329
Sum5.7278e+10
Variance7.8912e+17
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 32 5.7%
 
4.2e+05 10 1.8%
 
6.3e+05 5 0.9%
 
9.3e+05 5 0.9%
 
8.4e+05 2 0.4%
 
3.3364e+05 2 0.4%
 
1.14e+06 2 0.4%
 
1.35e+06 2 0.4%
 
1.2364e+05 2 0.4%
 
1.1127e+06 2 0.4%
 
Other values (228) 229 40.5%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1.2364e+05 2 0.4%
 
1.5455e+05 1 0.2%
 
1.6485e+05 1 0.2%
 
1.8546e+05 1 0.2%
 
2.1e+05 32 5.7%
 

Maximum 5 values

ValueCountFrequency (%) 
7.7807e+09 1 0.2%
 
7.5599e+09 1 0.2%
 
5.9645e+09 1 0.2%
 
5.223e+09 1 0.2%
 
4.1484e+09 1 0.2%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.96717

fl_antt
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
474
True
 
92
ValueCountFrequency (%) 
False 474 83.7%
 
True 92 16.3%
 

fl_email
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
304
True
262
ValueCountFrequency (%) 
False 304 53.7%
 
True 262 46.3%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
562
True
 
4
ValueCountFrequency (%) 
False 562 99.3%
 
True 4 0.7%
 

fl_matriz
Constant

This variable is constant and should be ignored for analysis

Constant valueTrue

fl_me
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
564
True
 
2
ValueCountFrequency (%) 
False 564 99.6%
 
True 2 0.4%
 

fl_mei
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_optante_simei
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_optante_simples
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
539
True
 
27
ValueCountFrequency (%) 
False 539 95.2%
 
True 27 4.8%
 

fl_passivel_iss
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
490
False
 
76
ValueCountFrequency (%) 
True 490 86.6%
 
False 76 13.4%
 

fl_rm
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
SIM
307
NAO
259
ValueCountFrequency (%) 
SIM 307 54.2%
 
NAO 259 45.8%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
543
True
 
23
ValueCountFrequency (%) 
False 543 95.9%
 
True 23 4.1%
 

fl_simples_irregular
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
565
True
 
1
ValueCountFrequency (%) 
False 565 99.8%
 
True 1 0.2%
 

fl_spa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
539
True
 
27
ValueCountFrequency (%) 
False 539 95.2%
 
True 27 4.8%
 

fl_st_especial
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
564
True
 
2
ValueCountFrequency (%) 
False 564 99.6%
 
True 2 0.4%
 

fl_telefone
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
307
False
259
ValueCountFrequency (%) 
True 307 54.2%
 
False 259 45.8%
 

fl_veiculo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
490
False
 
76
ValueCountFrequency (%) 
True 490 86.6%
 
False 76 13.4%
 

grau_instrucao_macro_analfabeto
Numeric

Distinct count18
Unique (%)3.2%
Missing (%)79.3%
Missing (n)449
Infinite (%)0.0%
Infinite (n)0
Mean5.1282
Minimum1
Maximum135
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q35
95-th percentile11.2
Maximum135
Range134
Interquartile range4

Descriptive statistics

Standard deviation14.434
Coef of variation2.8146
Kurtosis63.007
Mean5.1282
MAD5.1694
Skewness7.613
Sum600
Variance208.34
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 51 9.0%
 
2 20 3.5%
 
3 11 1.9%
 
6 7 1.2%
 
4 5 0.9%
 
10 4 0.7%
 
7 4 0.7%
 
9 3 0.5%
 
5 2 0.4%
 
11 2 0.4%
 
Other values (7) 8 1.4%
 
(Missing) 449 79.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 51 9.0%
 
2 20 3.5%
 
3 11 1.9%
 
4 5 0.9%
 
5 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
135 1 0.2%
 
80 1 0.2%
 
17 1 0.2%
 
14 1 0.2%
 
13 1 0.2%
 

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count157
Unique (%)27.7%
Missing (%)8.5%
Missing (n)48
Infinite (%)0.0%
Infinite (n)0
Mean73.212
Minimum1
Maximum3378
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q18
Median24.5
Q364.75
95-th percentile268.6
Maximum3378
Range3377
Interquartile range56.75

Descriptive statistics

Standard deviation205.92
Coef of variation2.8126
Kurtosis143.02
Mean73.212
MAD80.386
Skewness10.299
Sum37924
Variance42403
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 25 4.4%
 
2 24 4.2%
 
4 22 3.9%
 
3 18 3.2%
 
7 17 3.0%
 
10 13 2.3%
 
6 13 2.3%
 
13 13 2.3%
 
18 12 2.1%
 
9 12 2.1%
 
Other values (146) 349 61.7%
 
(Missing) 48 8.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 25 4.4%
 
2 24 4.2%
 
3 18 3.2%
 
4 22 3.9%
 
5 8 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3378 1 0.2%
 
1943 1 0.2%
 
1041 1 0.2%
 
971 1 0.2%
 
794 1 0.2%
 

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count268
Unique (%)47.3%
Missing (%)0.5%
Missing (n)3
Infinite (%)0.0%
Infinite (n)0
Mean189.25
Minimum1
Maximum10413
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile18
Q148
Median78
Q3167.5
95-th percentile547.4
Maximum10413
Range10412
Interquartile range119.5

Descriptive statistics

Standard deviation538.65
Coef of variation2.8463
Kurtosis235.73
Mean189.25
MAD184.5
Skewness13.389
Sum1.0655e+05
Variance2.9014e+05
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
73 8 1.4%
 
51 8 1.4%
 
38 8 1.4%
 
70 7 1.2%
 
55 7 1.2%
 
53 7 1.2%
 
72 7 1.2%
 
59 7 1.2%
 
43 7 1.2%
 
30 6 1.1%
 
Other values (257) 491 86.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.2%
 
3 1 0.2%
 
4 1 0.2%
 
5 2 0.4%
 
6 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
10413 1 0.2%
 
3256 1 0.2%
 
3054 1 0.2%
 
2447 1 0.2%
 
2387 1 0.2%
 

grau_instrucao_macro_escolaridade_superior
Numeric

Distinct count188
Unique (%)33.2%
Missing (%)3.0%
Missing (n)17
Infinite (%)0.0%
Infinite (n)0
Mean115.98
Minimum1
Maximum4791
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q18
Median25
Q385
95-th percentile381.6
Maximum4791
Range4790
Interquartile range77

Descriptive statistics

Standard deviation374.66
Coef of variation3.2304
Kurtosis79.781
Mean115.98
MAD140.54
Skewness8.1075
Sum63674
Variance1.4037e+05
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3 30 5.3%
 
2 27 4.8%
 
4 18 3.2%
 
7 17 3.0%
 
5 16 2.8%
 
1 15 2.7%
 
6 14 2.5%
 
10 12 2.1%
 
8 12 2.1%
 
12 11 1.9%
 
Other values (177) 377 66.6%
 
(Missing) 17 3.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 15 2.7%
 
2 27 4.8%
 
3 30 5.3%
 
4 18 3.2%
 
5 16 2.8%
 

Maximum 5 values

ValueCountFrequency (%) 
4791 1 0.2%
 
4152 1 0.2%
 
2807 1 0.2%
 
2652 1 0.2%
 
2161 1 0.2%
 

id
Categorical, Unique

First 5 values
00990ce9e5ed028c985c70d79caf6bfafec0611deacee65001879ae201e5d36b
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2
01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8e33b0a49a83f72238c
021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b2d65c44345f0ecc857
021d2faf177f995a2011eb905d14777ec5091106b121a4bdb7f4a6eac5fd978f
Last 5 values
ff4ce2406e71e486b19e95137147273a32f8dd218a78d7a5ea0952f135258ef9
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6
ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce37ba76d16469a8982a
ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac3ac349c280cae803fd
ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200aa897cbd7cb320cf8a2

First 5 values

ValueCountFrequency (%) 
00990ce9e5ed028c985c70d79caf6bfafec0611deacee65001879ae201e5d36b 1 0.2%
 
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 1 0.2%
 
01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8e33b0a49a83f72238c 1 0.2%
 
021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b2d65c44345f0ecc857 1 0.2%
 
021d2faf177f995a2011eb905d14777ec5091106b121a4bdb7f4a6eac5fd978f 1 0.2%
 

Last 5 values

ValueCountFrequency (%) 
ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200aa897cbd7cb320cf8a2 1 0.2%
 
ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac3ac349c280cae803fd 1 0.2%
 
ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce37ba76d16469a8982a 1 0.2%
 
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 1 0.2%
 
ff4ce2406e71e486b19e95137147273a32f8dd218a78d7a5ea0952f135258ef9 1 0.2%
 

idade_acima_de_58
Numeric

Distinct count100
Unique (%)17.7%
Missing (%)10.8%
Missing (n)61
Infinite (%)0.0%
Infinite (n)0
Mean40.749
Minimum1
Maximum3663
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
Median8
Q323
95-th percentile117
Maximum3663
Range3662
Interquartile range20

Descriptive statistics

Standard deviation203.01
Coef of variation4.982
Kurtosis218.01
Mean40.749
MAD52.517
Skewness13.587
Sum20578
Variance41213
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2 55 9.7%
 
1 55 9.7%
 
5 38 6.7%
 
3 32 5.7%
 
4 31 5.5%
 
7 21 3.7%
 
6 20 3.5%
 
8 17 3.0%
 
9 14 2.5%
 
11 13 2.3%
 
Other values (89) 209 36.9%
 
(Missing) 61 10.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 55 9.7%
 
2 55 9.7%
 
3 32 5.7%
 
4 31 5.5%
 
5 38 6.7%
 

Maximum 5 values

ValueCountFrequency (%) 
3663 1 0.2%
 
1844 1 0.2%
 
1401 1 0.2%
 
906 1 0.2%
 
674 1 0.2%
 

idade_ate_18
Numeric

Distinct count15
Unique (%)2.7%
Missing (%)62.0%
Missing (n)351
Infinite (%)0.0%
Infinite (n)0
Mean3.4558
Minimum1
Maximum83
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33.5
95-th percentile7
Maximum83
Range82
Interquartile range2.5

Descriptive statistics

Standard deviation7.1615
Coef of variation2.0723
Kurtosis85.449
Mean3.4558
MAD2.6082
Skewness8.6671
Sum743
Variance51.287
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 78 13.8%
 
2 51 9.0%
 
3 32 5.7%
 
4 14 2.5%
 
6 13 2.3%
 
5 11 1.9%
 
7 6 1.1%
 
8 3 0.5%
 
9 2 0.4%
 
10 1 0.2%
 
Other values (4) 4 0.7%
 
(Missing) 351 62.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 78 13.8%
 
2 51 9.0%
 
3 32 5.7%
 
4 14 2.5%
 
5 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
83 1 0.2%
 
56 1 0.2%
 
33 1 0.2%
 
12 1 0.2%
 
10 1 0.2%
 

idade_de_19_a_23
Numeric

Distinct count72
Unique (%)12.7%
Missing (%)16.6%
Missing (n)94
Infinite (%)0.0%
Infinite (n)0
Mean18.307
Minimum1
Maximum643
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
Median9
Q316.25
95-th percentile56.45
Maximum643
Range642
Interquartile range13.25

Descriptive statistics

Standard deviation45.5
Coef of variation2.4854
Kurtosis91.846
Mean18.307
MAD17.735
Skewness8.433
Sum8641
Variance2070.3
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 52 9.2%
 
2 38 6.7%
 
3 35 6.2%
 
4 25 4.4%
 
5 25 4.4%
 
8 24 4.2%
 
9 21 3.7%
 
11 20 3.5%
 
6 20 3.5%
 
10 17 3.0%
 
Other values (61) 195 34.5%
 
(Missing) 94 16.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 52 9.2%
 
2 38 6.7%
 
3 35 6.2%
 
4 25 4.4%
 
5 25 4.4%
 

Maximum 5 values

ValueCountFrequency (%) 
643 1 0.2%
 
373 1 0.2%
 
323 1 0.2%
 
286 1 0.2%
 
253 1 0.2%
 

idade_de_24_a_28
Numeric

Distinct count107
Unique (%)18.9%
Missing (%)3.0%
Missing (n)17
Infinite (%)0.0%
Infinite (n)0
Mean33.137
Minimum1
Maximum949
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile3
Q19
Median17
Q331
95-th percentile101.8
Maximum949
Range948
Interquartile range22

Descriptive statistics

Standard deviation66.397
Coef of variation2.0037
Kurtosis83.925
Mean33.137
MAD29.786
Skewness7.76
Sum18192
Variance4408.6
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
6 25 4.4%
 
12 22 3.9%
 
9 21 3.7%
 
7 20 3.5%
 
8 20 3.5%
 
15 20 3.5%
 
10 19 3.4%
 
21 19 3.4%
 
11 19 3.4%
 
17 17 3.0%
 
Other values (96) 347 61.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 11 1.9%
 
2 11 1.9%
 
3 15 2.7%
 
4 16 2.8%
 
5 13 2.3%
 

Maximum 5 values

ValueCountFrequency (%) 
949 1 0.2%
 
631 1 0.2%
 
486 1 0.2%
 
376 1 0.2%
 
359 1 0.2%
 

idade_de_29_a_33
Numeric

Distinct count136
Unique (%)24.0%
Missing (%)0.7%
Missing (n)4
Infinite (%)0.0%
Infinite (n)0
Mean49.623
Minimum1
Maximum785
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile7.05
Q114
Median23
Q345
95-th percentile169.8
Maximum785
Range784
Interquartile range31

Descriptive statistics

Standard deviation87.526
Coef of variation1.7638
Kurtosis30.979
Mean49.623
MAD44.244
Skewness5.0723
Sum27888
Variance7660.8
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
16 24 4.2%
 
9 22 3.9%
 
12 21 3.7%
 
15 21 3.7%
 
18 20 3.5%
 
13 19 3.4%
 
10 19 3.4%
 
19 17 3.0%
 
26 15 2.7%
 
8 15 2.7%
 
Other values (125) 369 65.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.2%
 
2 4 0.7%
 
3 3 0.5%
 
4 5 0.9%
 
5 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
785 1 0.2%
 
749 1 0.2%
 
714 1 0.2%
 
580 1 0.2%
 
559 1 0.2%
 

idade_de_34_a_38
Numeric

Distinct count148
Unique (%)26.1%
Missing (%)0.2%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean59.08
Minimum1
Maximum1884
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile8
Q115
Median25
Q349
95-th percentile178.4
Maximum1884
Range1883
Interquartile range34

Descriptive statistics

Standard deviation128.65
Coef of variation2.1775
Kurtosis87.798
Mean59.08
MAD56.537
Skewness7.9617
Sum33380
Variance16550
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
16 20 3.5%
 
13 19 3.4%
 
11 19 3.4%
 
21 18 3.2%
 
14 18 3.2%
 
10 17 3.0%
 
20 15 2.7%
 
17 15 2.7%
 
22 14 2.5%
 
12 14 2.5%
 
Other values (137) 396 70.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 2 0.4%
 
3 5 0.9%
 
4 1 0.2%
 
5 5 0.9%
 
6 8 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
1884 1 0.2%
 
1047 1 0.2%
 
1027 1 0.2%
 
923 1 0.2%
 
620 1 0.2%
 

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.95905

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation0.98342

idade_de_49_a_53
Highly correlated

This variable is highly correlated with idade_de_44_a_48 and should be ignored for analysis

Correlation0.99027

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation0.98514

idade_emp_cat
Categorical

Distinct count3
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
> 20
379
10 a 15
98
15 a 20
89
ValueCountFrequency (%) 
> 20 379 67.0%
 
10 a 15 98 17.3%
 
15 a 20 89 15.7%
 
Max length7
Mean length4.9912
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count486
Unique (%)85.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean26.988
Minimum10.038
Maximum55.126
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10.038
5-th percentile11.737
Q117.832
Median23.403
Q338.628
95-th percentile45.099
Maximum55.126
Range45.088
Interquartile range20.796

Descriptive statistics

Standard deviation11.638
Coef of variation0.43125
Kurtosis-1.0421
Mean26.988
MAD10.014
Skewness0.4655
Sum15275
Variance135.45
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[10.03835616 21.81506849 21.85342466 26.79178082 43.76575342 43.85342466 43.85616438 43.88219178 52.20547945 55.1260274 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
21.836 16 2.8%
 
43.855 14 2.5%
 
43.866 10 1.8%
 
21.833 7 1.2%
 
43.877 6 1.1%
 
43.868 5 0.9%
 
43.8 3 0.5%
 
21.816 3 0.5%
 
26.362 2 0.4%
 
18.512 2 0.4%
 
Other values (476) 498 88.0%
 

Minimum 5 values

ValueCountFrequency (%) 
10.038 1 0.2%
 
10.066 1 0.2%
 
10.285 1 0.2%
 
10.323 1 0.2%
 
10.364 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
55.126 1 0.2%
 
52.274 1 0.2%
 
52.137 1 0.2%
 
52.036 1 0.2%
 
51.852 1 0.2%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation0.99911

idade_maxima_socios
Numeric

Distinct count62
Unique (%)11.0%
Missing (%)37.6%
Missing (n)213
Infinite (%)0.0%
Infinite (n)0
Mean57.609
Minimum20
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20
5-th percentile35.6
Q149
Median59
Q366
95-th percentile78
Maximum90
Range70
Interquartile range17

Descriptive statistics

Standard deviation12.817
Coef of variation0.22249
Kurtosis-0.24842
Mean57.609
MAD10.337
Skewness-0.048472
Sum20336
Variance164.28
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
59 17 3.0%
 
61 16 2.8%
 
52 14 2.5%
 
57 13 2.3%
 
65 12 2.1%
 
54 12 2.1%
 
64 12 2.1%
 
55 12 2.1%
 
68 11 1.9%
 
66 10 1.8%
 
Other values (51) 224 39.6%
 
(Missing) 213 37.6%
 

Minimum 5 values

ValueCountFrequency (%) 
20 1 0.2%
 
28 1 0.2%
 
29 1 0.2%
 
30 2 0.4%
 
31 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
90 3 0.5%
 
89 1 0.2%
 
86 1 0.2%
 
84 2 0.4%
 
83 2 0.4%
 

idade_media_coligadas
Numeric

Distinct count300
Unique (%)53.0%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean174.32
Minimum2.7667
Maximum615.18
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.7667
5-th percentile35.37
Q198.146
Median156.06
Q3234.78
95-th percentile367.69
Maximum615.18
Range612.42
Interquartile range136.63

Descriptive statistics

Standard deviation105.31
Coef of variation0.60415
Kurtosis1.0267
Mean174.32
MAD83.184
Skewness0.92416
Sum52121
Variance11091
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
82.72 1 0.2%
 
194.17 1 0.2%
 
247.94 1 0.2%
 
128.69 1 0.2%
 
191.47 1 0.2%
 
245.22 1 0.2%
 
75.467 1 0.2%
 
189 1 0.2%
 
71.462 1 0.2%
 
161.37 1 0.2%
 
Other values (289) 289 51.1%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2.7667 1 0.2%
 
5.8 1 0.2%
 
8.9333 1 0.2%
 
9.4667 1 0.2%
 
13.65 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
615.18 1 0.2%
 
504.69 1 0.2%
 
495.95 1 0.2%
 
488.5 1 0.2%
 
444.53 1 0.2%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation0.9995

idade_media_coligadas_baixadas
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

idade_media_socios
Numeric

Distinct count144
Unique (%)25.4%
Missing (%)37.6%
Missing (n)213
Infinite (%)0.0%
Infinite (n)0
Mean51.557
Minimum20
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20
5-th percentile33.5
Q144
Median51.5
Q358.5
95-th percentile69.4
Maximum90
Range70
Interquartile range14.5

Descriptive statistics

Standard deviation11.068
Coef of variation0.21468
Kurtosis0.3014
Mean51.557
MAD8.7733
Skewness0.24258
Sum18199
Variance122.5
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
52 11 1.9%
 
47 9 1.6%
 
54 8 1.4%
 
46 8 1.4%
 
43.5 8 1.4%
 
50 8 1.4%
 
59 7 1.2%
 
56.5 7 1.2%
 
56 7 1.2%
 
44 7 1.2%
 
Other values (133) 273 48.2%
 
(Missing) 213 37.6%
 

Minimum 5 values

ValueCountFrequency (%) 
20 1 0.2%
 
27 2 0.4%
 
28 1 0.2%
 
29 1 0.2%
 
29.5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
90 2 0.4%
 
80.143 1 0.2%
 
79 2 0.4%
 
78 1 0.2%
 
76.5 1 0.2%
 

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation0.99963

idade_minima_socios
Numeric

Distinct count62
Unique (%)11.0%
Missing (%)37.6%
Missing (n)213
Infinite (%)0.0%
Infinite (n)0
Mean46.028
Minimum12
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum12
5-th percentile25.6
Q136
Median46
Q355
95-th percentile68
Maximum90
Range78
Interquartile range19

Descriptive statistics

Standard deviation13.071
Coef of variation0.28398
Kurtosis-0.077736
Mean46.028
MAD10.693
Skewness0.27433
Sum16248
Variance170.86
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
54 14 2.5%
 
34 13 2.3%
 
52 13 2.3%
 
36 12 2.1%
 
46 12 2.1%
 
57 12 2.1%
 
41 11 1.9%
 
39 11 1.9%
 
35 11 1.9%
 
50 11 1.9%
 
Other values (51) 233 41.2%
 
(Missing) 213 37.6%
 

Minimum 5 values

ValueCountFrequency (%) 
12 1 0.2%
 
19 1 0.2%
 
20 1 0.2%
 
21 2 0.4%
 
22 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
90 2 0.4%
 
79 1 0.2%
 
78 1 0.2%
 
76 2 0.4%
 
75 1 0.2%
 

max_faturamento_est_coligados
Numeric

Distinct count200
Unique (%)35.3%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean1.1648e+08
Minimum1.2364e+05
Maximum5.9628e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.2364e+05
5-th percentile2.1e+05
Q17.4183e+05
Median5.4401e+06
Q32.9982e+07
95-th percentile2.3008e+08
Maximum5.9628e+09
Range5.9627e+09
Interquartile range2.924e+07

Descriptive statistics

Standard deviation5.782e+08
Coef of variation4.9639
Kurtosis62.629
Mean1.1648e+08
MAD1.8406e+08
Skewness7.5526
Sum3.4129e+10
Variance3.3431e+17
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 52 9.2%
 
9.3e+05 16 2.8%
 
7.4183e+05 4 0.7%
 
1.1127e+06 4 0.7%
 
3.7092e+05 3 0.5%
 
2.8437e+06 2 0.4%
 
9.8911e+05 2 0.4%
 
1.7412e+07 2 0.4%
 
1.2364e+06 2 0.4%
 
4.451e+07 2 0.4%
 
Other values (189) 204 36.0%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1.2364e+05 2 0.4%
 
1.5455e+05 1 0.2%
 
1.6485e+05 1 0.2%
 
1.8546e+05 1 0.2%
 
2.1e+05 52 9.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5.9628e+09 1 0.2%
 
5.151e+09 1 0.2%
 
3.7745e+09 1 0.2%
 
2.9397e+09 1 0.2%
 
2.1245e+09 1 0.2%
 

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.94873

max_filiais_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.92095

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation0.95968

max_meses_servicos
Numeric

Distinct count447
Unique (%)79.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean339.44
Minimum7.6
Maximum5099.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7.6
5-th percentile84.825
Q1156.07
Median256.02
Q3438.92
95-th percentile584.43
Maximum5099.1
Range5091.5
Interquartile range282.85

Descriptive statistics

Standard deviation519.33
Coef of variation1.53
Kurtosis72.727
Mean339.44
MAD200.36
Skewness8.1902
Sum1.9212e+05
Variance2.6971e+05
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 7.6 91.65 95.75 253.3 253.53333333 ... 506.21666667 507.45 594.36666667 722.3 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
265.63 7 1.2%
 
5099.1 6 1.1%
 
265.67 5 0.9%
 
470.67 5 0.9%
 
253.47 5 0.9%
 
507.2 5 0.9%
 
236.3 4 0.7%
 
545.7 4 0.7%
 
92.233 4 0.7%
 
201.8 4 0.7%
 
Other values (437) 517 91.3%
 

Minimum 5 values

ValueCountFrequency (%) 
7.6 1 0.2%
 
21.133 1 0.2%
 
24.2 1 0.2%
 
29.6 1 0.2%
 
30.333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 6 1.1%
 
727 1 0.2%
 
717.6 1 0.2%
 
707.37 1 0.2%
 
706 1 0.2%
 

max_meses_servicos_all
Numeric

Distinct count383
Unique (%)67.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1420.1
Minimum7.6
Maximum5099.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7.6
5-th percentile94.125
Q1176.38
Median284.05
Q3626.35
95-th percentile5039.3
Maximum5099.1
Range5091.5
Interquartile range449.97

Descriptive statistics

Standard deviation2053.6
Coef of variation1.4461
Kurtosis-0.5809
Mean1420.1
MAD1758.9
Skewness1.1844
Sum8.0376e+05
Variance4.2172e+06
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 7.6 91.65 253.3 253.53333333 267.68333333 ... 550.73333333 707.61666667 5008.88333333 5021.06666667 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5015 102 18.0%
 
5064.7 18 3.2%
 
5099.1 6 1.1%
 
5039.3 5 0.9%
 
5027.2 4 0.7%
 
201.8 4 0.7%
 
265.63 4 0.7%
 
253.47 3 0.5%
 
254.53 3 0.5%
 
168.2 3 0.5%
 
Other values (373) 414 73.1%
 

Minimum 5 values

ValueCountFrequency (%) 
7.6 1 0.2%
 
21.2 1 0.2%
 
24.2 1 0.2%
 
29.6 1 0.2%
 
38.433 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 6 1.1%
 
5065.7 2 0.4%
 
5064.7 18 3.2%
 
5039.3 5 0.9%
 
5027.2 4 0.7%
 

max_vl_folha_coligados
Numeric

Distinct count188
Unique (%)33.2%
Missing (%)58.7%
Missing (n)332
Infinite (%)0.0%
Infinite (n)0
Mean1.7944e+07
Minimum61819
Maximum3.5404e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819
5-th percentile1.2364e+05
Q18.8608e+05
Median4.0492e+06
Q31.223e+07
95-th percentile8.0761e+07
Maximum3.5404e+08
Range3.5398e+08
Interquartile range1.1344e+07

Descriptive statistics

Standard deviation4.5464e+07
Coef of variation2.5336
Kurtosis25.193
Mean1.7944e+07
MAD2.2338e+07
Skewness4.7056
Sum4.1989e+09
Variance2.067e+15
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 9 1.6%
 
2.4728e+05 5 0.9%
 
5.5637e+05 4 0.7%
 
1.2364e+05 3 0.5%
 
3.7092e+05 3 0.5%
 
1.4424e+05 3 0.5%
 
1.257e+06 3 0.5%
 
6.1819e+05 3 0.5%
 
1.8546e+05 3 0.5%
 
1.6959e+07 2 0.4%
 
Other values (177) 196 34.6%
 
(Missing) 332 58.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819 9 1.6%
 
82426 1 0.2%
 
1.0303e+05 1 0.2%
 
1.2364e+05 3 0.5%
 
1.4424e+05 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
3.5404e+08 1 0.2%
 
3.1303e+08 1 0.2%
 
2.4398e+08 1 0.2%
 
2.0771e+08 1 0.2%
 
2.0392e+08 1 0.2%
 

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9326

media_faturamento_est_coligados
Numeric

Distinct count237
Unique (%)41.9%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean1.6857e+07
Minimum1.2364e+05
Maximum1.1929e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.2364e+05
5-th percentile2.1e+05
Q13.8319e+05
Median1.9905e+06
Q37.8792e+06
95-th percentile4.2989e+07
Maximum1.1929e+09
Range1.1928e+09
Interquartile range7.496e+06

Descriptive statistics

Standard deviation8.2355e+07
Coef of variation4.8856
Kurtosis148.75
Mean1.6857e+07
MAD2.3582e+07
Skewness11.271
Sum4.939e+09
Variance6.7823e+15
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 49 8.7%
 
9.3e+05 5 0.9%
 
1.2364e+05 2 0.4%
 
1.1127e+06 2 0.4%
 
1.6682e+05 2 0.4%
 
4.5e+05 2 0.4%
 
5.7e+05 2 0.4%
 
7.4183e+05 1 0.2%
 
3.1796e+06 1 0.2%
 
3.1584e+06 1 0.2%
 
Other values (226) 226 39.9%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1.2364e+05 2 0.4%
 
1.5455e+05 1 0.2%
 
1.6485e+05 1 0.2%
 
1.6682e+05 2 0.4%
 
1.8121e+05 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1.1929e+09 1 0.2%
 
5.1855e+08 1 0.2%
 
3.482e+08 1 0.2%
 
3.04e+08 1 0.2%
 
2.1e+08 1 0.2%
 

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.97553

media_filiais_coligados
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.93788

media_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation0.97637

media_meses_servicos
Numeric

Distinct count566
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean94.173
Minimum5.5541
Maximum459.97
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.5541
5-th percentile24.093
Q143.726
Median69.796
Q3146.37
95-th percentile211.79
Maximum459.97
Range454.41
Interquartile range102.64

Descriptive statistics

Standard deviation67.051
Coef of variation0.71199
Kurtosis2.2185
Mean94.173
MAD54.899
Skewness1.281
Sum53302
Variance4495.8
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 5.5541387 23.48033312 57.21315789 81.80277904 200.91285363 247.56763822 459.96901121], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
44.588 1 0.2%
 
223.04 1 0.2%
 
64.525 1 0.2%
 
167.65 1 0.2%
 
12.775 1 0.2%
 
24.963 1 0.2%
 
47.901 1 0.2%
 
163.25 1 0.2%
 
70.287 1 0.2%
 
142.8 1 0.2%
 
Other values (556) 556 98.2%
 

Minimum 5 values

ValueCountFrequency (%) 
5.5541 1 0.2%
 
5.6098 1 0.2%
 
7.5586 1 0.2%
 
7.8968 1 0.2%
 
8.4043 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
459.97 1 0.2%
 
409.3 1 0.2%
 
353.95 1 0.2%
 
319.02 1 0.2%
 
313.49 1 0.2%
 

media_meses_servicos_all
Numeric

Distinct count566
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean80.261
Minimum2.7073
Maximum944.63
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.7073
5-th percentile12.328
Q124.679
Median43.504
Q3113.48
95-th percentile241.55
Maximum944.63
Range941.93
Interquartile range88.8

Descriptive statistics

Standard deviation88.567
Coef of variation1.1035
Kurtosis18.79
Mean80.261
MAD62.934
Skewness3.1463
Sum45428
Variance7844.1
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 2.70732436 10.45628531 37.64888255 64.36235372 173.7754826 249.26943319 364.54312211 944.63353181], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
41.333 1 0.2%
 
99.279 1 0.2%
 
51.131 1 0.2%
 
27.848 1 0.2%
 
29.978 1 0.2%
 
29.744 1 0.2%
 
55.641 1 0.2%
 
73.271 1 0.2%
 
30.596 1 0.2%
 
11.399 1 0.2%
 
Other values (556) 556 98.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2.7073 1 0.2%
 
6.9806 1 0.2%
 
6.9941 1 0.2%
 
7.1839 1 0.2%
 
8.1179 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
944.63 1 0.2%
 
533.92 1 0.2%
 
519.21 1 0.2%
 
452.33 1 0.2%
 
430.08 1 0.2%
 

media_vl_folha_coligados
Numeric

Distinct count213
Unique (%)37.6%
Missing (%)58.7%
Missing (n)332
Infinite (%)0.0%
Infinite (n)0
Mean7.12e+06
Minimum61819
Maximum3.5404e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819
5-th percentile1.1643e+05
Q16.1819e+05
Median2.1194e+06
Q35.3963e+06
95-th percentile2.1135e+07
Maximum3.5404e+08
Range3.5398e+08
Interquartile range4.7781e+06

Descriptive statistics

Standard deviation2.6367e+07
Coef of variation3.7032
Kurtosis132.71
Mean7.12e+06
MAD8.2936e+06
Skewness10.705
Sum1.6661e+09
Variance6.952e+14
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 9 1.6%
 
6.1819e+05 3 0.5%
 
2.4728e+05 3 0.5%
 
1.4424e+05 3 0.5%
 
1.8546e+05 3 0.5%
 
5.5637e+05 2 0.4%
 
6.8001e+05 2 0.4%
 
1.6485e+05 2 0.4%
 
1.257e+06 2 0.4%
 
1.2364e+05 2 0.4%
 
Other values (202) 203 35.9%
 
(Missing) 332 58.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819 9 1.6%
 
82426 1 0.2%
 
92729 1 0.2%
 
1.0303e+05 1 0.2%
 
1.2364e+05 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3.5404e+08 1 0.2%
 
1.2942e+08 1 0.2%
 
1.2343e+08 1 0.2%
 
4.8631e+07 1 0.2%
 
4.0188e+07 1 0.2%
 

media_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.93982

meses_ultima_contratacaco
Numeric

Distinct count212
Unique (%)37.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.003
Minimum1.9333
Maximum405.73
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.9333
5-th percentile2.0333
Q12.4417
Median3.9333
Q323.95
95-th percentile34.367
Maximum405.73
Range403.8
Interquartile range21.508

Descriptive statistics

Standard deviation21.492
Coef of variation1.6528
Kurtosis197.63
Mean13.003
MAD12.468
Skewness11.233
Sum7359.7
Variance461.9
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1.93333333 2.28333333 2.31666667 2.91666667 2.96666667 ... 28.31666667 34.3 34.38333333 64.5 405.73333333], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2.9333 37 6.5%
 
2.3 32 5.7%
 
23.2 18 3.2%
 
2 16 2.8%
 
2.0667 16 2.8%
 
2.2667 16 2.8%
 
2.5333 13 2.3%
 
3.9333 12 2.1%
 
2.7667 12 2.1%
 
2.2 12 2.1%
 
Other values (202) 382 67.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1.9333 1 0.2%
 
1.9667 4 0.7%
 
2 16 2.8%
 
2.0333 12 2.1%
 
2.0667 16 2.8%
 

Maximum 5 values

ValueCountFrequency (%) 
405.73 1 0.2%
 
106.37 1 0.2%
 
65.833 1 0.2%
 
63.167 1 0.2%
 
62.833 1 0.2%
 

min_faturamento_est_coligados
Numeric

Distinct count61
Unique (%)10.8%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean1.1133e+06
Minimum0
Maximum6.0995e+07
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile79429
Q12.1e+05
Median2.1e+05
Q32.1e+05
95-th percentile3.8843e+06
Maximum6.0995e+07
Range6.0995e+07
Interquartile range0

Descriptive statistics

Standard deviation4.7212e+06
Coef of variation4.2405
Kurtosis99.342
Mean1.1133e+06
MAD1.5638e+06
Skewness9.1002
Sum3.2621e+08
Variance2.229e+13
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 173 30.6%
 
1.2364e+05 26 4.6%
 
1.8546e+05 7 1.2%
 
41213 6 1.1%
 
9.3e+05 6 1.1%
 
2.0606e+05 4 0.7%
 
1.5455e+05 3 0.5%
 
82426 3 0.5%
 
74933 2 0.4%
 
6.1819e+05 2 0.4%
 
Other values (50) 61 10.8%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
9141 1 0.2%
 
19079 1 0.2%
 
41213 6 1.1%
 
50000 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
6.0995e+07 1 0.2%
 
3.3794e+07 1 0.2%
 
2.3182e+07 1 0.2%
 
2.1328e+07 1 0.2%
 
2.0091e+07 1 0.2%
 

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.94763

min_filiais_coligados
Numeric

Distinct count10
Unique (%)1.8%
Missing (%)73.0%
Missing (n)413
Infinite (%)0.0%
Infinite (n)0
Mean1.719
Minimum1
Maximum33
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile5
Maximum33
Range32
Interquartile range0

Descriptive statistics

Standard deviation2.8573
Coef of variation1.6622
Kurtosis95.774
Mean1.719
MAD1.1184
Skewness9.0067
Sum263
Variance8.1639
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 119 21.0%
 
2 17 3.0%
 
3 5 0.9%
 
5 3 0.5%
 
4 3 0.5%
 
8 2 0.4%
 
6 2 0.4%
 
7 1 0.2%
 
33 1 0.2%
 
(Missing) 413 73.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 119 21.0%
 
2 17 3.0%
 
3 5 0.9%
 
4 3 0.5%
 
5 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
33 1 0.2%
 
8 2 0.4%
 
7 1 0.2%
 
6 2 0.4%
 
5 3 0.5%
 

min_funcionarios_coligados_gp
Numeric

Distinct count59
Unique (%)10.4%
Missing (%)55.5%
Missing (n)314
Infinite (%)0.0%
Infinite (n)0
Mean27.286
Minimum0
Maximum2112
Zeros (%)16.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1.5
Q310
95-th percentile100.25
Maximum2112
Range2112
Interquartile range10

Descriptive statistics

Standard deviation143.46
Coef of variation5.2578
Kurtosis180.08
Mean27.286
MAD40.739
Skewness12.67
Sum6876
Variance20582
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 93 16.4%
 
1 33 5.8%
 
2 16 2.8%
 
3 14 2.5%
 
4 8 1.4%
 
5 7 1.2%
 
7 6 1.1%
 
10 6 1.1%
 
9 5 0.9%
 
6 5 0.9%
 
Other values (48) 59 10.4%
 
(Missing) 314 55.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 93 16.4%
 
1 33 5.8%
 
2 16 2.8%
 
3 14 2.5%
 
4 8 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2112 1 0.2%
 
592 1 0.2%
 
360 1 0.2%
 
257 1 0.2%
 
235 1 0.2%
 

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation0.98348

min_meses_servicos_all
Numeric

Distinct count152
Unique (%)26.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.84376
Minimum-12.033
Maximum266.17
Zeros (%)6.2%
Mini histogram

Quantile statistics

Minimum-12.033
5-th percentile-6.1
Q1-0.63333
Median-0.26667
Q30.4
95-th percentile8.1333
Maximum266.17
Range278.2
Interquartile range1.0333

Descriptive statistics

Standard deviation12.152
Coef of variation14.402
Kurtosis403.93
Mean0.84376
MAD3.0247
Skewness18.649
Sum477.57
Variance147.68
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[-1.20333333e+01 -1.05000000e+00 -8.16666667e-01 -3.16666667e-01 -5.00000000e-02 ... 2.98333333e+00 3.10000000e+00 1.20666667e+01 3.48666667e+01 2.66166667e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 35 6.2%
 
-0.033333 30 5.3%
 
-0.63333 24 4.2%
 
-0.5 23 4.1%
 
-0.7 18 3.2%
 
-0.36667 16 2.8%
 
-0.43333 14 2.5%
 
-0.56667 13 2.3%
 
1 13 2.3%
 
-0.33333 12 2.1%
 
Other values (142) 368 65.0%
 

Minimum 5 values

ValueCountFrequency (%) 
-12.033 1 0.2%
 
-11.9 1 0.2%
 
-11.667 1 0.2%
 
-11.2 3 0.5%
 
-11.167 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
266.17 1 0.2%
 
35.4 1 0.2%
 
34.333 1 0.2%
 
27.5 1 0.2%
 
27.267 1 0.2%
 

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with media_vl_folha_coligados and should be ignored for analysis

Correlation0.92717

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation0.95645

natureza_juridica_macro
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)0.0%
Missing (n)0
ENTIDADES EMPRESARIAIS
323
OUTROS
152
ADMINISTRACAO PUBLICA
 
56
ValueCountFrequency (%) 
ENTIDADES EMPRESARIAIS 323 57.1%
 
OUTROS 152 26.9%
 
ADMINISTRACAO PUBLICA 56 9.9%
 
ENTIDADES SEM FINS LUCRATIVOS 35 6.2%
 
Max length29
Mean length18.037
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count60
Unique (%)10.6%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
163
COMERCIO VAREJISTA
 
46
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS
 
40
Other values (57)
317
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 163 28.8%
 
COMERCIO VAREJISTA 46 8.1%
 
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS 40 7.1%
 
EDUCACAO 33 5.8%
 
CONSTRUCAO DE EDIFICIOS 31 5.5%
 
ATIVIDADES DE ATENCAO A SAUDE HUMANA 22 3.9%
 
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS 22 3.9%
 
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 21 3.7%
 
TRANSPORTE TERRESTRE 20 3.5%
 
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS 11 1.9%
 
Other values (50) 157 27.7%
 
Max length120
Mean length41.193
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count19
Unique (%)3.4%
Missing (%)12.4%
Missing (n)70
CENTRO AMAZONENSE
138
NORTE MARANHENSE
66
CENTRO NORTE PIAUIENSE
62
Other values (15)
230
(Missing)
70
ValueCountFrequency (%) 
CENTRO AMAZONENSE 138 24.4%
 
NORTE MARANHENSE 66 11.7%
 
CENTRO NORTE PIAUIENSE 62 11.0%
 
LESTE POTIGUAR 52 9.2%
 
VALE DO ACRE 32 5.7%
 
OESTE POTIGUAR 28 4.9%
 
OESTE MARANHENSE 16 2.8%
 
SUDESTE PIAUIENSE 15 2.7%
 
CENTRO MARANHENSE 14 2.5%
 
SUDOESTE PIAUIENSE 14 2.5%
 
Other values (8) 59 10.4%
 
(Missing) 70 12.4%
 
Max length22
Mean length14.823
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count61
Unique (%)10.8%
Missing (%)12.4%
Missing (n)70
MANAUS
126
AGLOMERACAO URBANA DE SAO LUIS
58
NATAL
 
48
Other values (57)
264
(Missing)
70
ValueCountFrequency (%) 
MANAUS 126 22.3%
 
AGLOMERACAO URBANA DE SAO LUIS 58 10.2%
 
NATAL 48 8.5%
 
TERESINA 46 8.1%
 
RIO BRANCO 29 5.1%
 
MOSSORO 16 2.8%
 
IMPERATRIZ 12 2.1%
 
MEDIO MEARIM 8 1.4%
 
ALTO MEDIO CANINDE 8 1.4%
 
PICOS 7 1.2%
 
Other values (50) 138 24.4%
 
(Missing) 70 12.4%
 
Max length33
Mean length10.749
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count19
Unique (%)3.4%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
163
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
107
INDUSTRIAS DE TRANSFORMACAO
64
Other values (16)
232
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 163 28.8%
 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 107 18.9%
 
INDUSTRIAS DE TRANSFORMACAO 64 11.3%
 
CONSTRUCAO 46 8.1%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 42 7.4%
 
EDUCACAO 33 5.8%
 
TRANSPORTE ARMAZENAGEM E CORREIO 25 4.4%
 
SAUDE HUMANA E SERVICOS SOCIAIS 25 4.4%
 
OUTRAS ATIVIDADES DE SERVICOS 12 2.1%
 
ALOJAMENTO E ALIMENTACAO 11 1.9%
 
Other values (9) 38 6.7%
 
Max length62
Mean length39.799
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count11
Unique (%)1.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean24.753
Minimum21
Maximum49
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum21
5-th percentile23
Q123
Median23
Q323
95-th percentile48
Maximum49
Range28
Interquartile range0

Descriptive statistics

Standard deviation5.923
Coef of variation0.23929
Kurtosis11.23
Mean24.753
MAD2.9508
Skewness3.5895
Sum14010
Variance35.082
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[21. 22.5 23.5 24.5 25.5 26.5 27.5 47.5 48.5 49. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
23 410 72.4%
 
24 64 11.3%
 
48 29 5.1%
 
26 24 4.2%
 
22 18 3.2%
 
27 6 1.1%
 
21 5 0.9%
 
47 4 0.7%
 
25 4 0.7%
 
28 1 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
21 5 0.9%
 
22 18 3.2%
 
23 410 72.4%
 
24 64 11.3%
 
25 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 0.2%
 
48 29 5.1%
 
47 4 0.7%
 
28 1 0.2%
 
27 6 1.1%
 

percent_func_genero_fem
Numeric

Distinct count535
Unique (%)94.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean40.565
Minimum0
Maximum87.5
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile3.955
Q117.94
Median42.86
Q361.883
95-th percentile76.468
Maximum87.5
Range87.5
Interquartile range43.943

Descriptive statistics

Standard deviation24.417
Coef of variation0.60193
Kurtosis-1.2919
Mean40.565
MAD21.669
Skewness-0.036441
Sum22960
Variance596.2
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 58.07 70.125 87.5 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
50 5 0.9%
 
51.58 3 0.5%
 
72.93 3 0.5%
 
30.26 2 0.4%
 
52.01 2 0.4%
 
51.97 2 0.4%
 
3.95 2 0.4%
 
42.86 2 0.4%
 
69.14 2 0.4%
 
64.88 2 0.4%
 
Other values (525) 541 95.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
0.5 1 0.2%
 
0.56 1 0.2%
 
0.68 2 0.4%
 
0.89 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
87.5 1 0.2%
 
87.19 1 0.2%
 
86.9 1 0.2%
 
86.26 1 0.2%
 
86.06 1 0.2%
 

percent_func_genero_masc
Numeric

Distinct count535
Unique (%)94.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean59.435
Minimum12.5
Maximum100
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum12.5
5-th percentile23.532
Q138.117
Median57.14
Q382.06
95-th percentile96.045
Maximum100
Range87.5
Interquartile range43.943

Descriptive statistics

Standard deviation24.417
Coef of variation0.41082
Kurtosis-1.2919
Mean59.435
MAD21.668
Skewness0.03644
Sum33640
Variance596.2
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 12.5 29.875 41.93 100. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
50 5 0.9%
 
48.42 3 0.5%
 
27.07 3 0.5%
 
95.65 2 0.4%
 
30.86 2 0.4%
 
35.71 2 0.4%
 
48.03 2 0.4%
 
35.11 2 0.4%
 
60.29 2 0.4%
 
41.15 2 0.4%
 
Other values (525) 541 95.6%
 

Minimum 5 values

ValueCountFrequency (%) 
12.5 1 0.2%
 
12.81 1 0.2%
 
13.1 1 0.2%
 
13.74 1 0.2%
 
13.94 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
100 1 0.2%
 
99.5 1 0.2%
 
99.44 1 0.2%
 
99.32 2 0.4%
 
99.11 1 0.2%
 

qt_admitidos
Numeric

Distinct count444
Unique (%)78.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean961.98
Minimum24
Maximum21259
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum24
5-th percentile133.5
Q1257.75
Median435
Q3904.5
95-th percentile3936.8
Maximum21259
Range21235
Interquartile range646.75

Descriptive statistics

Standard deviation1740.2
Coef of variation1.809
Kurtosis42.738
Mean961.98
MAD873.61
Skewness5.4655
Sum5.4448e+05
Variance3.0283e+06
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 24. 144.5 344.5 551.5 1153.5 2012.5 8307.5 21259. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
246 5 0.9%
 
419 4 0.7%
 
210 4 0.7%
 
275 4 0.7%
 
309 3 0.5%
 
311 3 0.5%
 
156 3 0.5%
 
293 3 0.5%
 
501 3 0.5%
 
270 3 0.5%
 
Other values (434) 531 93.8%
 

Minimum 5 values

ValueCountFrequency (%) 
24 1 0.2%
 
33 1 0.2%
 
53 1 0.2%
 
66 1 0.2%
 
76 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
21259 1 0.2%
 
11739 1 0.2%
 
11544 1 0.2%
 
11466 1 0.2%
 
8340 1 0.2%
 

qt_admitidos_12meses
Numeric

Distinct count125
Unique (%)22.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean37.571
Minimum0
Maximum1256
Zeros (%)35.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median9
Q335
95-th percentile158.75
Maximum1256
Range1256
Interquartile range35

Descriptive statistics

Standard deviation93.702
Coef of variation2.494
Kurtosis61.172
Mean37.571
MAD45.28
Skewness6.5011
Sum21265
Variance8780
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.850e+01 3.050e+01 7.700e+01 1.105e+02 2.390e+02 6.080e+02 1.256e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 199 35.2%
 
10 12 2.1%
 
6 12 2.1%
 
14 11 1.9%
 
1 11 1.9%
 
16 11 1.9%
 
4 11 1.9%
 
5 10 1.8%
 
2 10 1.8%
 
7 9 1.6%
 
Other values (115) 270 47.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 199 35.2%
 
1 11 1.9%
 
2 10 1.8%
 
3 9 1.6%
 
4 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
1256 1 0.2%
 
642 1 0.2%
 
574 1 0.2%
 
554 2 0.4%
 
475 1 0.2%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Numeric

Distinct count48
Unique (%)8.5%
Missing (%)53.7%
Missing (n)304
Infinite (%)0.0%
Infinite (n)0
Mean11.16
Minimum1
Maximum426
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q39
95-th percentile43
Maximum426
Range425
Interquartile range8

Descriptive statistics

Standard deviation31.223
Coef of variation2.7977
Kurtosis121.19
Mean11.16
MAD12.57
Skewness9.7215
Sum2924
Variance974.88
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 68 12.0%
 
2 42 7.4%
 
3 30 5.3%
 
4 18 3.2%
 
6 13 2.3%
 
5 12 2.1%
 
14 6 1.1%
 
8 6 1.1%
 
11 6 1.1%
 
10 6 1.1%
 
Other values (37) 55 9.7%
 
(Missing) 304 53.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 68 12.0%
 
2 42 7.4%
 
3 30 5.3%
 
4 18 3.2%
 
5 12 2.1%
 

Maximum 5 values

ValueCountFrequency (%) 
426 1 0.2%
 
126 1 0.2%
 
118 1 0.2%
 
103 1 0.2%
 
98 1 0.2%
 

qt_coligadas
Numeric

Distinct count32
Unique (%)5.7%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean7.1304
Minimum1
Maximum296
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median3
Q37
95-th percentile21.3
Maximum296
Range295
Interquartile range5

Descriptive statistics

Standard deviation18.999
Coef of variation2.6644
Kurtosis180.91
Mean7.1304
MAD6.6506
Skewness12.238
Sum2132
Variance360.95
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 71 12.5%
 
2 46 8.1%
 
3 40 7.1%
 
4 32 5.7%
 
5 19 3.4%
 
6 14 2.5%
 
9 11 1.9%
 
7 10 1.8%
 
8 8 1.4%
 
10 8 1.4%
 
Other values (21) 40 7.1%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 71 12.5%
 
2 46 8.1%
 
3 40 7.1%
 
4 32 5.7%
 
5 19 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
296 1 0.2%
 
68 1 0.2%
 
57 1 0.2%
 
53 2 0.4%
 
48 1 0.2%
 

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation1

qt_coligados_agropecuaria
Numeric

Distinct count7
Unique (%)1.2%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.22408
Minimum0
Maximum9
Zeros (%)46.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.90113
Coef of variation4.0215
Kurtosis61.004
Mean0.22408
MAD0.3972
Skewness7.0219
Sum67
Variance0.81204
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 265 46.8%
 
1 20 3.5%
 
2 8 1.4%
 
3 3 0.5%
 
9 2 0.4%
 
4 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 265 46.8%
 
1 20 3.5%
 
2 8 1.4%
 
3 3 0.5%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
9 2 0.4%
 
4 1 0.2%
 
3 3 0.5%
 
2 8 1.4%
 
1 20 3.5%
 

qt_coligados_atividade_alto
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_inativo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_medio
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_mt_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.99984

qt_coligados_baixada
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)47.2%
Missing (n)267
0
298
1
 
1
(Missing)
267
ValueCountFrequency (%) 
0 298 52.7%
 
1 1 0.2%
 
(Missing) 267 47.2%
 

qt_coligados_ccivil
Numeric

Distinct count12
Unique (%)2.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.4381
Minimum0
Maximum270
Zeros (%)38.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile3
Maximum270
Range270
Interquartile range1

Descriptive statistics

Standard deviation15.654
Coef of variation10.885
Kurtosis293.63
Mean1.4381
MAD2.257
Skewness17.064
Sum430
Variance245.03
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 220 38.9%
 
1 48 8.5%
 
2 15 2.7%
 
3 8 1.4%
 
4 2 0.4%
 
270 1 0.2%
 
7 1 0.2%
 
8 1 0.2%
 
12 1 0.2%
 
13 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 220 38.9%
 
1 48 8.5%
 
2 15 2.7%
 
3 8 1.4%
 
4 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
270 1 0.2%
 
13 1 0.2%
 
12 1 0.2%
 
10 1 0.2%
 
8 1 0.2%
 

qt_coligados_centro
Numeric

Distinct count9
Unique (%)1.6%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.20401
Minimum0
Maximum13
Zeros (%)48.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum13
Range13
Interquartile range0

Descriptive statistics

Standard deviation1.05
Coef of variation5.1468
Kurtosis89.794
Mean0.20401
MAD0.37118
Skewness8.7235
Sum61
Variance1.1025
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
0 272 48.1%
 
1 18 3.2%
 
2 4 0.7%
 
8 1 0.2%
 
3 1 0.2%
 
4 1 0.2%
 
13 1 0.2%
 
7 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 272 48.1%
 
1 18 3.2%
 
2 4 0.7%
 
3 1 0.2%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
13 1 0.2%
 
8 1 0.2%
 
7 1 0.2%
 
4 1 0.2%
 
3 1 0.2%
 

qt_coligados_comercio
Numeric

Distinct count15
Unique (%)2.7%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.408
Minimum0
Maximum25
Zeros (%)26.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32
95-th percentile6
Maximum25
Range25
Interquartile range2

Descriptive statistics

Standard deviation2.7831
Coef of variation1.9766
Kurtosis27.489
Mean1.408
MAD1.609
Skewness4.5106
Sum421
Variance7.7457
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 152 26.9%
 
1 65 11.5%
 
2 28 4.9%
 
3 24 4.2%
 
4 10 1.8%
 
6 5 0.9%
 
8 4 0.7%
 
5 4 0.7%
 
14 2 0.4%
 
15 1 0.2%
 
Other values (4) 4 0.7%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 152 26.9%
 
1 65 11.5%
 
2 28 4.9%
 
3 24 4.2%
 
4 10 1.8%
 

Maximum 5 values

ValueCountFrequency (%) 
25 1 0.2%
 
20 1 0.2%
 
15 1 0.2%
 
14 2 0.4%
 
11 1 0.2%
 

qt_coligados_epp
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_exterior
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)47.2%
Missing (n)267
0
291
1
 
5
2
 
3
(Missing)
267
ValueCountFrequency (%) 
0 291 51.4%
 
1 5 0.9%
 
2 3 0.5%
 
(Missing) 267 47.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_inapta
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)47.2%
Missing (n)267
0
290
1
 
8
2
 
1
(Missing)
267
ValueCountFrequency (%) 
0 290 51.2%
 
1 8 1.4%
 
2 1 0.2%
 
(Missing) 267 47.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_industria
Numeric

Distinct count11
Unique (%)1.9%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.82274
Minimum0
Maximum48
Zeros (%)37.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile3
Maximum48
Range48
Interquartile range1

Descriptive statistics

Standard deviation3.4367
Coef of variation4.1771
Kurtosis127.19
Mean0.82274
MAD1.1612
Skewness10.29
Sum246
Variance11.811
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 211 37.3%
 
1 54 9.5%
 
2 15 2.7%
 
3 9 1.6%
 
4 3 0.5%
 
6 2 0.4%
 
21 2 0.4%
 
10 1 0.2%
 
48 1 0.2%
 
11 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 211 37.3%
 
1 54 9.5%
 
2 15 2.7%
 
3 9 1.6%
 
4 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
48 1 0.2%
 
21 2 0.4%
 
11 1 0.2%
 
10 1 0.2%
 
6 2 0.4%
 

qt_coligados_ltda
Numeric

Distinct count6
Unique (%)1.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.086957
Minimum0
Maximum8
Zeros (%)50.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.61234
Coef of variation7.0419
Kurtosis122.72
Mean0.086957
MAD0.16635
Skewness10.544
Sum26
Variance0.37496
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 286 50.5%
 
1 10 1.8%
 
2 1 0.2%
 
8 1 0.2%
 
6 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 286 50.5%
 
1 10 1.8%
 
2 1 0.2%
 
6 1 0.2%
 
8 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.2%
 
6 1 0.2%
 
2 1 0.2%
 
1 10 1.8%
 
0 286 50.5%
 

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.99904

qt_coligados_me
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_mei
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)47.2%
Missing (n)267
0
297
1
 
2
(Missing)
267
ValueCountFrequency (%) 
0 297 52.5%
 
1 2 0.4%
 
(Missing) 267 47.2%
 

qt_coligados_nordeste
Numeric

Distinct count23
Unique (%)4.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean2.8328
Minimum0
Maximum41
Zeros (%)24.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q34
95-th percentile13
Maximum41
Range41
Interquartile range4

Descriptive statistics

Standard deviation5.3732
Coef of variation1.8968
Kurtosis19.608
Mean2.8328
MAD3.2835
Skewness3.8214
Sum847
Variance28.871
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 141 24.9%
 
1 39 6.9%
 
2 24 4.2%
 
4 21 3.7%
 
3 19 3.4%
 
6 10 1.8%
 
5 8 1.4%
 
9 8 1.4%
 
10 5 0.9%
 
7 3 0.5%
 
Other values (12) 21 3.7%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 141 24.9%
 
1 39 6.9%
 
2 24 4.2%
 
3 19 3.4%
 
4 21 3.7%
 

Maximum 5 values

ValueCountFrequency (%) 
41 2 0.4%
 
28 1 0.2%
 
25 2 0.4%
 
21 1 0.2%
 
17 2 0.4%
 

qt_coligados_norte
Numeric

Distinct count20
Unique (%)3.5%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.9398
Minimum0
Maximum52
Zeros (%)28.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32
95-th percentile9
Maximum52
Range52
Interquartile range2

Descriptive statistics

Standard deviation4.657
Coef of variation2.4008
Kurtosis51.956
Mean1.9398
MAD2.4025
Skewness6.0715
Sum580
Variance21.688
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 159 28.1%
 
1 54 9.5%
 
2 22 3.9%
 
3 18 3.2%
 
4 11 1.9%
 
5 8 1.4%
 
6 4 0.7%
 
7 4 0.7%
 
9 4 0.7%
 
14 3 0.5%
 
Other values (9) 12 2.1%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 159 28.1%
 
1 54 9.5%
 
2 22 3.9%
 
3 18 3.2%
 
4 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
52 1 0.2%
 
32 1 0.2%
 
23 1 0.2%
 
19 1 0.2%
 
17 1 0.2%
 

qt_coligados_nula
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_sa
Highly correlated

This variable is highly correlated with qt_coligados_industria and should be ignored for analysis

Correlation0.92957

qt_coligados_serviço
Numeric

Distinct count26
Unique (%)4.6%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean3.2441
Minimum0
Maximum51
Zeros (%)10.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q33
95-th percentile12
Maximum51
Range51
Interquartile range2

Descriptive statistics

Standard deviation5.6245
Coef of variation1.7337
Kurtosis25.503
Mean3.2441
MAD3.16
Skewness4.371
Sum970
Variance31.635
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 93 16.4%
 
0 61 10.8%
 
2 48 8.5%
 
3 25 4.4%
 
4 19 3.4%
 
7 14 2.5%
 
12 6 1.1%
 
6 6 1.1%
 
5 6 1.1%
 
8 4 0.7%
 
Other values (15) 17 3.0%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 61 10.8%
 
1 93 16.4%
 
2 48 8.5%
 
3 25 4.4%
 
4 19 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
51 1 0.2%
 
37 1 0.2%
 
31 1 0.2%
 
30 1 0.2%
 
25 1 0.2%
 

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.92867

qt_coligados_sul
Numeric

Distinct count6
Unique (%)1.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.11037
Minimum0
Maximum16
Zeros (%)50.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum16
Range16
Interquartile range0

Descriptive statistics

Standard deviation1.0056
Coef of variation9.1115
Kurtosis214.49
Mean0.11037
MAD0.21188
Skewness14.048
Sum33
Variance1.0113
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 287 50.7%
 
1 9 1.6%
 
2 1 0.2%
 
6 1 0.2%
 
16 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 287 50.7%
 
1 9 1.6%
 
2 1 0.2%
 
6 1 0.2%
 
16 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
16 1 0.2%
 
6 1 0.2%
 
2 1 0.2%
 
1 9 1.6%
 
0 287 50.7%
 

qt_coligados_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_desligados
Numeric

Distinct count414
Unique (%)73.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean591.69
Minimum7
Maximum11079
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile28.5
Q1120
Median238
Q3544.25
95-th percentile2180
Maximum11079
Range11072
Interquartile range424.25

Descriptive statistics

Standard deviation1141.4
Coef of variation1.9291
Kurtosis30.347
Mean591.69
MAD585.06
Skewness4.9176
Sum3.349e+05
Variance1.3028e+06
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[7.0000e+00 2.6900e+02 5.4350e+02 9.1750e+02 1.8270e+03 4.3580e+03 1.1079e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
199 5 0.9%
 
124 5 0.9%
 
214 4 0.7%
 
378 4 0.7%
 
221 4 0.7%
 
153 4 0.7%
 
9 3 0.5%
 
89 3 0.5%
 
52 3 0.5%
 
106 3 0.5%
 
Other values (404) 528 93.3%
 

Minimum 5 values

ValueCountFrequency (%) 
7 1 0.2%
 
8 3 0.5%
 
9 3 0.5%
 
10 1 0.2%
 
11 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
11079 1 0.2%
 
9979 1 0.2%
 
7843 1 0.2%
 
7233 1 0.2%
 
6802 1 0.2%
 

qt_desligados_12meses
Numeric

Distinct count111
Unique (%)19.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean31.654
Minimum0
Maximum1041
Zeros (%)33.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median9
Q329
95-th percentile119.5
Maximum1041
Range1041
Interquartile range29

Descriptive statistics

Standard deviation78.75
Coef of variation2.4879
Kurtosis58.536
Mean31.654
MAD37.434
Skewness6.3919
Sum17916
Variance6201.6
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 2.250e+01 5.450e+01 9.400e+01 1.565e+02 5.185e+02 1.041e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 187 33.0%
 
10 16 2.8%
 
7 15 2.7%
 
1 13 2.3%
 
4 11 1.9%
 
5 11 1.9%
 
6 11 1.9%
 
15 11 1.9%
 
12 11 1.9%
 
18 11 1.9%
 
Other values (101) 269 47.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 187 33.0%
 
1 13 2.3%
 
2 10 1.8%
 
3 9 1.6%
 
4 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
1041 1 0.2%
 
557 1 0.2%
 
480 1 0.2%
 
460 1 0.2%
 
443 1 0.2%
 

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation1

qt_filiais
Numeric

Distinct count35
Unique (%)6.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.4346
Minimum0
Maximum172
Zeros (%)47.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile13
Maximum172
Range172
Interquartile range2

Descriptive statistics

Standard deviation11.804
Coef of variation3.4367
Kurtosis106.49
Mean3.4346
MAD4.4989
Skewness9.2098
Sum1944
Variance139.33
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 6.5 10.5 16.5 56. 172. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 270 47.7%
 
1 108 19.1%
 
2 49 8.7%
 
3 29 5.1%
 
4 18 3.2%
 
6 18 3.2%
 
5 10 1.8%
 
7 9 1.6%
 
10 8 1.4%
 
8 6 1.1%
 
Other values (25) 41 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 270 47.7%
 
1 108 19.1%
 
2 49 8.7%
 
3 29 5.1%
 
4 18 3.2%
 

Maximum 5 values

ValueCountFrequency (%) 
172 1 0.2%
 
121 1 0.2%
 
116 1 0.2%
 
61 1 0.2%
 
51 1 0.2%
 

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_54_a_58 and should be ignored for analysis

Correlation0.94732

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.99761

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.98334

qt_funcionarios_coligados
Numeric

Distinct count163
Unique (%)28.8%
Missing (%)55.5%
Missing (n)314
Infinite (%)0.0%
Infinite (n)0
Mean359.66
Minimum0
Maximum7222
Zeros (%)3.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q110.75
Median80.5
Q3229.25
95-th percentile1727.7
Maximum7222
Range7222
Interquartile range218.5

Descriptive statistics

Standard deviation897.39
Coef of variation2.4951
Kurtosis21.645
Mean359.66
MAD460.51
Skewness4.3418
Sum90635
Variance8.053e+05
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 18 3.2%
 
1 9 1.6%
 
3 7 1.2%
 
2 5 0.9%
 
4 4 0.7%
 
9 4 0.7%
 
7 4 0.7%
 
6 4 0.7%
 
12 3 0.5%
 
20 3 0.5%
 
Other values (152) 191 33.7%
 
(Missing) 314 55.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 18 3.2%
 
1 9 1.6%
 
2 5 0.9%
 
3 7 1.2%
 
4 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
7222 1 0.2%
 
4770 1 0.2%
 
4487 1 0.2%
 
4311 1 0.2%
 
4124 1 0.2%
 

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation0.90605

qt_funcionarios_grupo
Numeric

Distinct count351
Unique (%)62.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean580.98
Minimum17
Maximum95202
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum17
5-th percentile60.25
Q199
Median178
Q3375.25
95-th percentile1285.2
Maximum95202
Range95185
Interquartile range276.25

Descriptive statistics

Standard deviation4111.2
Coef of variation7.0762
Kurtosis499.53
Mean580.98
MAD662.11
Skewness21.811
Sum3.2884e+05
Variance1.6902e+07
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[1.7000e+01 4.9500e+01 1.2750e+02 2.1350e+02 4.1450e+02 7.8950e+02 1.6140e+03 6.3160e+03 9.5202e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
96 7 1.2%
 
98 7 1.2%
 
71 7 1.2%
 
94 6 1.1%
 
123 6 1.1%
 
142 6 1.1%
 
110 5 0.9%
 
77 5 0.9%
 
73 5 0.9%
 
79 4 0.7%
 
Other values (341) 508 89.8%
 

Minimum 5 values

ValueCountFrequency (%) 
17 1 0.2%
 
21 1 0.2%
 
38 1 0.2%
 
40 1 0.2%
 
42 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
95202 1 0.2%
 
17969 1 0.2%
 
6622 1 0.2%
 
6010 1 0.2%
 
5759 1 0.2%
 

qt_ramos_coligados
Numeric

Distinct count22
Unique (%)3.9%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean4.1304
Minimum1
Maximum30
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q35
95-th percentile12.1
Maximum30
Range29
Interquartile range4

Descriptive statistics

Standard deviation4.1893
Coef of variation1.0142
Kurtosis11.049
Mean4.1304
MAD2.7887
Skewness2.8221
Sum1235
Variance17.55
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 76 13.4%
 
2 54 9.5%
 
3 53 9.4%
 
4 31 5.5%
 
5 20 3.5%
 
7 14 2.5%
 
8 11 1.9%
 
6 10 1.8%
 
10 9 1.6%
 
15 3 0.5%
 
Other values (11) 18 3.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 76 13.4%
 
2 54 9.5%
 
3 53 9.4%
 
4 31 5.5%
 
5 20 3.5%
 

Maximum 5 values

ValueCountFrequency (%) 
30 2 0.4%
 
21 1 0.2%
 
19 1 0.2%
 
18 2 0.4%
 
17 1 0.2%
 

qt_regioes_coligados
Numeric

Distinct count6
Unique (%)1.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.3445
Minimum1
Maximum5
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31.5
95-th percentile3
Maximum5
Range4
Interquartile range0.5

Descriptive statistics

Standard deviation0.69398
Coef of variation0.51617
Kurtosis6.1631
Mean1.3445
MAD0.51615
Skewness2.3901
Sum402
Variance0.48161
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
1 224 39.6%
 
2 56 9.9%
 
3 11 1.9%
 
4 7 1.2%
 
5 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 224 39.6%
 
2 56 9.9%
 
3 11 1.9%
 
4 7 1.2%
 
5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.2%
 
4 7 1.2%
 
3 11 1.9%
 
2 56 9.9%
 
1 224 39.6%
 

qt_socios
Numeric

Distinct count15
Unique (%)2.7%
Missing (%)32.5%
Missing (n)184
Infinite (%)0.0%
Infinite (n)0
Mean3.0995
Minimum1
Maximum139
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median2
Q33
95-th percentile6
Maximum139
Range138
Interquartile range1

Descriptive statistics

Standard deviation7.2366
Coef of variation2.3348
Kurtosis328.78
Mean3.0995
MAD1.6803
Skewness17.547
Sum1184
Variance52.368
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2 181 32.0%
 
3 65 11.5%
 
1 55 9.7%
 
4 42 7.4%
 
5 14 2.5%
 
6 13 2.3%
 
7 3 0.5%
 
9 3 0.5%
 
139 1 0.2%
 
13 1 0.2%
 
Other values (4) 4 0.7%
 
(Missing) 184 32.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 55 9.7%
 
2 181 32.0%
 
3 65 11.5%
 
4 42 7.4%
 
5 14 2.5%
 

Maximum 5 values

ValueCountFrequency (%) 
139 1 0.2%
 
22 1 0.2%
 
14 1 0.2%
 
13 1 0.2%
 
12 1 0.2%
 

qt_socios_coligados
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.96791

qt_socios_feminino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation0.98778

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios_feminino and should be ignored for analysis

Correlation0.96613

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.97676

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9745

qt_socios_pj
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)32.5%
Missing (n)184
0
331
1
 
35
2
 
15
(Missing)
184
ValueCountFrequency (%) 
0 331 58.5%
 
1 35 6.2%
 
2 15 2.7%
 
3 1 0.2%
 
(Missing) 184 32.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation0.96283

qt_socios_pj_baixados
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)91.0%
Missing (n)515
0
 
50
1
 
1
(Missing)
515
ValueCountFrequency (%) 
0 50 8.8%
 
1 1 0.2%
 
(Missing) 515 91.0%
 

qt_socios_pj_inaptos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_nulos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_suspensos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.99433

qt_socios_st_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_ufs_coligados
Numeric

Distinct count12
Unique (%)2.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.7458
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile5
Maximum11
Range10
Interquartile range1

Descriptive statistics

Standard deviation1.5573
Coef of variation0.892
Kurtosis14.305
Mean1.7458
MAD0.95784
Skewness3.4833
Sum522
Variance2.4251
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 192 33.9%
 
2 64 11.3%
 
3 22 3.9%
 
5 6 1.1%
 
4 4 0.7%
 
6 3 0.5%
 
7 2 0.4%
 
11 2 0.4%
 
9 2 0.4%
 
10 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 192 33.9%
 
2 64 11.3%
 
3 22 3.9%
 
4 4 0.7%
 
5 6 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
11 2 0.4%
 
10 1 0.2%
 
9 2 0.4%
 
8 1 0.2%
 
7 2 0.4%
 

setor
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)0.0%
Missing (n)0
SERVIÇO
336
COMERCIO
107
INDUSTRIA
69
Other values (2)
 
54
ValueCountFrequency (%) 
SERVIÇO 336 59.4%
 
COMERCIO 107 18.9%
 
INDUSTRIA 69 12.2%
 
CONSTRUÇÃO CIVIL 46 8.1%
 
AGROPECUARIA 8 1.4%
 
Max length16
Mean length8.235
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
AM
142
MA
118
PI
101
Other values (3)
205
ValueCountFrequency (%) 
AM 142 25.1%
 
MA 118 20.8%
 
PI 101 17.8%
 
RN 100 17.7%
 
RO 70 12.4%
 
AC 35 6.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
AM
142
MA
118
PI
101
Other values (3)
205
ValueCountFrequency (%) 
AM 142 25.1%
 
MA 118 20.8%
 
PI 101 17.8%
 
RN 100 17.7%
 
RO 70 12.4%
 
AC 35 6.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.96717

total
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation0.97843

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.92158

tx_crescimento_12meses
Numeric

Distinct count355
Unique (%)62.7%
Missing (%)0.2%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean4.7448
Minimum-79.462
Maximum376.32
Zeros (%)34.5%
Mini histogram

Quantile statistics

Minimum-79.462
5-th percentile-18.051
Q1-0.98039
Median0
Q35
95-th percentile35.846
Maximum376.32
Range455.78
Interquartile range5.9804

Descriptive statistics

Standard deviation28.294
Coef of variation5.9632
Kurtosis74.962
Mean4.7448
MAD12.075
Skewness6.9998
Sum2680.8
Variance800.55
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 195 34.5%
 
1.0638 3 0.5%
 
2.5641 3 0.5%
 
11.321 2 0.4%
 
-6.8966 2 0.4%
 
21.905 2 0.4%
 
-1.3514 2 0.4%
 
2.7027 2 0.4%
 
10.169 2 0.4%
 
-2.0202 2 0.4%
 
Other values (344) 350 61.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-79.462 1 0.2%
 
-65.948 1 0.2%
 
-44.304 1 0.2%
 
-41.27 1 0.2%
 
-40.854 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
376.32 1 0.2%
 
290.48 1 0.2%
 
181.55 1 0.2%
 
133.33 1 0.2%
 
126.67 1 0.2%
 

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.96385

tx_rotatividade
Numeric

Distinct count362
Unique (%)64.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.801
Minimum0
Maximum133.88
Zeros (%)33.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median8.4636
Q319.84
95-th percentile46.42
Maximum133.88
Range133.88
Interquartile range19.84

Descriptive statistics

Standard deviation18.288
Coef of variation1.3251
Kurtosis8.8707
Mean13.801
MAD12.95
Skewness2.4553
Sum7811.1
Variance334.44
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 1.39295166e-02 2.26734117e+01 4.26816479e+01 5.92415730e+01 1.33877551e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 188 33.2%
 
38.462 3 0.5%
 
22.642 2 0.4%
 
5.2288 2 0.4%
 
19.512 2 0.4%
 
27.586 2 0.4%
 
19.355 2 0.4%
 
10.909 2 0.4%
 
8.2759 2 0.4%
 
10.811 2 0.4%
 
Other values (352) 359 63.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 188 33.2%
 
0.027859 1 0.2%
 
0.13387 1 0.2%
 
0.14316 1 0.2%
 
0.28902 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
133.88 1 0.2%
 
114.43 1 0.2%
 
113.96 1 0.2%
 
106.67 1 0.2%
 
95.904 1 0.2%
 

vl_faturamento_estimado_aux
Numeric

Distinct count480
Unique (%)84.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean8.1049e+07
Minimum1.0015e+07
Maximum3.4909e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.0015e+07
5-th percentile1.1024e+07
Q11.8507e+07
Median3.0406e+07
Q36.3313e+07
95-th percentile2.9249e+08
Maximum3.4909e+09
Range3.4809e+09
Interquartile range4.4806e+07

Descriptive statistics

Standard deviation2.2205e+08
Coef of variation2.7398
Kurtosis119.27
Mean8.1049e+07
MAD8.2627e+07
Skewness9.5819
Sum4.5874e+10
Variance4.9308e+16
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[1.00147100e+07 1.25183880e+07 3.11414220e+07 4.10840100e+07 7.22769500e+07 1.53105555e+08 5.26290040e+08 3.49093020e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.1024e+07 5 0.9%
 
1.9267e+07 5 0.9%
 
2.7355e+07 3 0.5%
 
1.1591e+07 3 0.5%
 
1.7515e+07 3 0.5%
 
1.2467e+07 3 0.5%
 
2.1328e+07 3 0.5%
 
1.0046e+07 3 0.5%
 
1.5764e+07 3 0.5%
 
1.1746e+07 3 0.5%
 
Other values (470) 532 94.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1.0015e+07 1 0.2%
 
1.0046e+07 3 0.5%
 
1.0097e+07 2 0.4%
 
1.0138e+07 1 0.2%
 
1.0149e+07 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3.4909e+09 1 0.2%
 
2.0688e+09 1 0.2%
 
1.7005e+09 1 0.2%
 
1.5354e+09 1 0.2%
 
1.3759e+09 1 0.2%
 

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count528
Unique (%)93.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.99e+07
Minimum1.0015e+07
Maximum4.6638e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.0015e+07
5-th percentile1.1552e+07
Q12.0204e+07
Median3.493e+07
Q37.5112e+07
95-th percentile3.2661e+08
Maximum4.6638e+09
Range4.6538e+09
Interquartile range5.4908e+07

Descriptive statistics

Standard deviation3.0304e+08
Coef of variation3.0334
Kurtosis125.51
Mean9.99e+07
MAD1.0515e+08
Skewness10.055
Sum5.6543e+10
Variance9.1831e+16
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[1.00147100e+07 3.09921700e+07 6.07708500e+07 9.03075470e+07 1.53592375e+08 2.69689685e+08 6.77425150e+08 4.66380100e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.1024e+07 5 0.9%
 
1.1746e+07 3 0.5%
 
2.7355e+07 3 0.5%
 
4.0955e+07 3 0.5%
 
1.0921e+07 3 0.5%
 
3.0497e+07 3 0.5%
 
1.2312e+07 2 0.4%
 
2.1328e+07 2 0.4%
 
4.0131e+07 2 0.4%
 
1.0097e+07 2 0.4%
 
Other values (518) 538 95.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1.0015e+07 1 0.2%
 
1.0046e+07 2 0.4%
 
1.0097e+07 2 0.4%
 
1.0138e+07 1 0.2%
 
1.0406e+07 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
4.6638e+09 1 0.2%
 
3.52e+09 1 0.2%
 
2.0777e+09 1 0.2%
 
1.7005e+09 1 0.2%
 
1.5545e+09 1 0.2%
 

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.92165

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.90572

vl_frota
Numeric

Distinct count467
Unique (%)82.5%
Missing (%)17.3%
Missing (n)98
Infinite (%)0.0%
Infinite (n)0
Mean9.6479e+05
Minimum3435
Maximum3.832e+07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3435
5-th percentile25751
Q11.0064e+05
Median2.9737e+05
Q36.3126e+05
95-th percentile3.7128e+06
Maximum3.832e+07
Range3.8317e+07
Interquartile range5.3062e+05

Descriptive statistics

Standard deviation2.7903e+06
Coef of variation2.8922
Kurtosis78.569
Mean9.6479e+05
MAD1.1407e+06
Skewness7.5687
Sum4.5152e+08
Variance7.7859e+12
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1.739e+05 2 0.4%
 
64657 2 0.4%
 
2.7255e+05 1 0.2%
 
40655 1 0.2%
 
59795 1 0.2%
 
5.8706e+05 1 0.2%
 
3.0684e+05 1 0.2%
 
2.5454e+05 1 0.2%
 
6.7206e+05 1 0.2%
 
34236 1 0.2%
 
Other values (456) 456 80.6%
 
(Missing) 98 17.3%
 

Minimum 5 values

ValueCountFrequency (%) 
3435 1 0.2%
 
3611 1 0.2%
 
3705 1 0.2%
 
4361 1 0.2%
 
4610 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
3.832e+07 1 0.2%
 
1.866e+07 1 0.2%
 
1.6423e+07 1 0.2%
 
1.5787e+07 1 0.2%
 
1.5604e+07 1 0.2%
 

vl_idade_maxima_socios_pj
Numeric

Distinct count51
Unique (%)9.0%
Missing (%)91.0%
Missing (n)515
Infinite (%)0.0%
Infinite (n)0
Mean13.374
Minimum0.76112
Maximum52.282
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.76112
5-th percentile1.6605
Q14.1821
Median7.102
Q318.658
95-th percentile39.648
Maximum52.282
Range51.521
Interquartile range14.476

Descriptive statistics

Standard deviation12.985
Coef of variation0.9709
Kurtosis1.3448
Mean13.374
MAD10.24
Skewness1.4101
Sum682.1
Variance168.62
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
15.343 2 0.4%
 
17.298 1 0.2%
 
4.0794 1 0.2%
 
3.5565 1 0.2%
 
12.159 1 0.2%
 
34.242 1 0.2%
 
19.121 1 0.2%
 
2.0616 1 0.2%
 
0.8679 1 0.2%
 
15.439 1 0.2%
 
Other values (40) 40 7.1%
 
(Missing) 515 91.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0.76112 1 0.2%
 
0.8679 1 0.2%
 
1.3388 1 0.2%
 
1.9822 1 0.2%
 
2.0616 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
52.282 1 0.2%
 
49.374 1 0.2%
 
41.402 1 0.2%
 
37.895 1 0.2%
 
34.242 1 0.2%
 

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation0.93323

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation0.92519

vl_potenc_cons_oleo_gas
Numeric

Distinct count62
Unique (%)11.0%
Missing (%)83.4%
Missing (n)472
Infinite (%)0.0%
Infinite (n)0
Mean78.468
Minimum1
Maximum1080
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile3
Q114.25
Median44.5
Q381.5
95-th percentile308.45
Maximum1080
Range1079
Interquartile range67.25

Descriptive statistics

Standard deviation136.42
Coef of variation1.7385
Kurtosis31.586
Mean78.468
MAD73.751
Skewness4.8865
Sum7376
Variance18610
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
45 8 1.4%
 
6 5 0.9%
 
4 5 0.9%
 
18 4 0.7%
 
20 3 0.5%
 
3 3 0.5%
 
7 3 0.5%
 
60 3 0.5%
 
30 2 0.4%
 
2 2 0.4%
 
Other values (51) 56 9.9%
 
(Missing) 472 83.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.2%
 
2 2 0.4%
 
3 3 0.5%
 
4 5 0.9%
 
5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1080 1 0.2%
 
430 1 0.2%
 
380 1 0.2%
 
374 1 0.2%
 
352 1 0.2%
 

vl_total_tancagem
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.94313

vl_total_tancagem_grupo
Numeric

Distinct count11
Unique (%)1.9%
Missing (%)94.7%
Missing (n)536
Infinite (%)0.0%
Infinite (n)0
Mean45.867
Minimum10
Maximum385
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10
5-th percentile15
Q115
Median17.5
Q330
95-th percentile177.5
Maximum385
Range375
Interquartile range15

Descriptive statistics

Standard deviation78.134
Coef of variation1.7035
Kurtosis13.537
Mean45.867
MAD42.169
Skewness3.6079
Sum1376
Variance6104.9
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
15 14 2.5%
 
30 5 0.9%
 
20 3 0.5%
 
45 2 0.4%
 
245 1 0.2%
 
385 1 0.2%
 
10 1 0.2%
 
91 1 0.2%
 
95 1 0.2%
 
40 1 0.2%
 
(Missing) 536 94.7%
 

Minimum 5 values

ValueCountFrequency (%) 
10 1 0.2%
 
15 14 2.5%
 
20 3 0.5%
 
30 5 0.9%
 
40 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
385 1 0.2%
 
245 1 0.2%
 
95 1 0.2%
 
91 1 0.2%
 
45 2 0.4%
 

vl_total_veiculos_antt
Highly correlated

This variable is highly correlated with vl_total_tancagem_grupo and should be ignored for analysis

Correlation0.9644

vl_total_veiculos_antt_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt and should be ignored for analysis

Correlation1

vl_total_veiculos_leves
Numeric

Distinct count59
Unique (%)10.4%
Missing (%)13.4%
Missing (n)76
Infinite (%)0.0%
Infinite (n)0
Mean11.645
Minimum0
Maximum359
Zeros (%)8.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median5
Q310
95-th percentile41.55
Maximum359
Range359
Interquartile range8

Descriptive statistics

Standard deviation27.507
Coef of variation2.3621
Kurtosis64.13
Mean11.645
MAD12.088
Skewness6.8574
Sum5706
Variance756.62
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 61 10.8%
 
2 51 9.0%
 
0 47 8.3%
 
3 46 8.1%
 
5 38 6.7%
 
4 33 5.8%
 
6 23 4.1%
 
7 23 4.1%
 
10 19 3.4%
 
9 17 3.0%
 
Other values (48) 132 23.3%
 
(Missing) 76 13.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 47 8.3%
 
1 61 10.8%
 
2 51 9.0%
 
3 46 8.1%
 
4 33 5.8%
 

Maximum 5 values

ValueCountFrequency (%) 
359 1 0.2%
 
194 1 0.2%
 
170 1 0.2%
 
167 1 0.2%
 
164 1 0.2%
 

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis

Correlation0.95902

vl_total_veiculos_pesados
Numeric

Distinct count59
Unique (%)10.4%
Missing (%)13.4%
Missing (n)76
Infinite (%)0.0%
Infinite (n)0
Mean9.849
Minimum0
Maximum215
Zeros (%)29.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median2
Q38
95-th percentile46
Maximum215
Range215
Interquartile range8

Descriptive statistics

Standard deviation24.115
Coef of variation2.4485
Kurtosis30.729
Mean9.849
MAD12.202
Skewness5.0185
Sum4826
Variance581.52
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 165 29.2%
 
1 55 9.7%
 
2 42 7.4%
 
3 29 5.1%
 
4 24 4.2%
 
7 19 3.4%
 
5 15 2.7%
 
9 14 2.5%
 
6 13 2.3%
 
8 11 1.9%
 
Other values (48) 103 18.2%
 
(Missing) 76 13.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 165 29.2%
 
1 55 9.7%
 
2 42 7.4%
 
3 29 5.1%
 
4 24 4.2%
 

Maximum 5 values

ValueCountFrequency (%) 
215 1 0.2%
 
190 1 0.2%
 
187 1 0.2%
 
176 1 0.2%
 
142 1 0.2%
 

vl_total_veiculos_pesados_grupo
Numeric

Distinct count65
Unique (%)11.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean10.408
Minimum0
Maximum663
Zeros (%)41.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q37
95-th percentile46
Maximum663
Range663
Interquartile range7

Descriptive statistics

Standard deviation36.866
Coef of variation3.542
Kurtosis179.17
Mean10.408
MAD13.944
Skewness11.328
Sum5891
Variance1359.1
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 2.500e+00 4.500e+00 1.050e+01 2.050e+01 4.950e+01 2.025e+02 6.630e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 237 41.9%
 
1 54 9.5%
 
2 41 7.2%
 
3 28 4.9%
 
4 25 4.4%
 
5 17 3.0%
 
7 16 2.8%
 
6 15 2.7%
 
9 13 2.3%
 
10 10 1.8%
 
Other values (55) 110 19.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 237 41.9%
 
1 54 9.5%
 
2 41 7.2%
 
3 28 4.9%
 
4 25 4.4%
 

Maximum 5 values

ValueCountFrequency (%) 
663 1 0.2%
 
215 1 0.2%
 
190 1 0.2%
 
187 1 0.2%
 
179 1 0.2%
 

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0NaNNaNNaNNaNDE R$ 300.000.000,01 A R$ 500.000.000,00DE R$ 300.000.000,01 A R$ 500.000.000,00BOAAUTARQUIA ESTADUAL OU DO DISTRITO FEDERALALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2007-08-032791.15NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN2.0523.0836.009e95c1a84049001d086470a8f320a19b076f955a89122ff8360ac2e4d6eca5d2.0NaNNaN23.0411.0508.0282.0103.022.010.010 a 1511.243836NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN357.066667357.066667NaNNaNNaNNaNNaNNaN99.96100984.967827NaNNaN25.533333NaNNaNNaNNaN25.533333-6.500000NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALVALE DO ACRERIO BRANCOADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.018.2281.781812.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN451.00.0451.001361.01361.01383.0NaNNaN1361.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOACACNaN1361.0NaN0.000000-1.5907450.000000327487200.0327487200.0NaNNaN46132.0NaNNaNNaNNaNNaNNaNNaNNaN4.04.00.00.0
1NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00BOAMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2004-12-111007.87NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN54.0414.0523.0dc9d155f5bcd3172031e2ec9431786e8871ff4b0ff4728bb62194ca0842cce3e123.0NaN11.059.0104.0157.0129.0163.0113.0132.0> 2043.789041NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN526.1333335014.966667NaNNaNNaNNaNNaNNaN149.17309180.756709NaNNaN23.200000NaNNaNNaNNaN23.200000-9.233333NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALAGRESTE POTIGUARAGRESTE POTIGUARADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.057.1142.892352.00.0NaNNaNNaNNaN8.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1361.00.01359.00991.0991.01306.0NaNNaN991.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN991.0NaN0.000000-24.1194490.000000176802910.0176802910.0NaNNaN1309391.0NaNNaNNaNNaNNaNNaNNaNNaN20.020.016.016.0
2NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE SIMPLES LIMITADAALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2005-09-24688.31NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN19.09.091.016843c9ffb920170477118933798510d8d5f00f5c56c1221773356355bded3212.0NaN1.010.027.030.020.015.011.03.015 a 2016.389041NaN70.0NaNNaNNaN70.000000NaN70.0NaNNaNNaNNaN149.033333149.033333NaNNaNNaNNaNNaNNaN65.94201742.166782NaNNaN4.866667NaNNaNNaNNaN4.8666670.000000NaNNaNENTIDADES EMPRESARIAISEDUCACAONORTE PIAUIENSEBAIXO PARNAIBA PIAUIENSEEDUCACAO23.047.9052.10291.021.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN172.07.0172.00119.0104.0113.0NaNNaN119.0NaNNaN2.0NaN1.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaN119.0NaN14.4230775.3097356.25000027818640.027818640.0NaNNaN60101.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.01.01.0
3NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2005-09-241397.47NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseFalseNaNNaN8.022.01794.0ff045934d90aab184dd15e66daf3b3c97193bda5449298784b664681610609a0143.0NaN16.090.0213.0352.0382.0264.0199.0165.0> 2039.671233NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN555.766667555.766667NaNNaNNaNNaNNaNNaN144.013013140.449941NaNNaN28.300000NaNNaNNaNNaN28.3000000.966667NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALSUDOESTE AMAZONENSEALTO SOLIMOESADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.051.9748.031971.00.0NaNNaNNaNNaN11.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN142.00.0141.011829.01829.01875.0NaNNaN1824.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOAMAMNaN1824.0NaN0.000000-2.4533330.000000221518800.0221518800.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
4372.066667NaN172.400000NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTAPRODUTOS DE AGROPECUARIAACIMA DE 1 ANOVERDE2005-11-03707.2014789028.016899028.0TrueFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrue14.0NaN153.05.03.0a0ce528caab2c62497a548d0ebd9e935143ef81ed7dbf074dcd7e0c7dd50ae111.03.021.019.026.023.031.026.014.011.0> 2020.268493372.06666770.0243.600000243.600000NaN48.666667172.40000036.010148652.012258652.01.065.0134.833333179.7666674059460.84059460.84929676.05.633009e+061.061.514.61073411.0008692.915806e+062.915806e+062.933333210000.0210000.01.058.02.933333-0.5666671772150.41772150.4ENTIDADES EMPRESARIAISAGRICULTURA PECUARIA E SERVICOS RELACIONADOSOESTE POTIGUARMOSSOROAGRICULTURA PECUARIA PRODUCAO FLORESTAL PESCA E AQUICULTURA23.05.1494.86614.0110.0NaNNaNNaNNaNNaN3.03.03.00.00.00.00.00.03.00.00.00.00.00.00.00.00.00.03.00.00.03.00.00.00.00.00.00.00.0437.063.0435.00177.0130.0120.0123.0123.0175.01.01.04.04.0NaN3.0NaN4.00.0NaNNaNNaNNaNNaN3.0NaN1.0AGROPECUARIARNRN14789028.0175.01.036.15384647.50000041.04234528127736.028127736.05831611.1255831611.125488926.0NaNNaNNaN6.0NaNNaNNaNNaN12.012.03.03.0
592.100000NaN92.100000NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE2005-09-242508.11930000.01140000.0TrueTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN3.0128.04.077ed856930ed9c2b5348eca951d152b5655c98af3bb44616674eaaa17846c7c7NaN3.022.032.029.027.015.03.03.01.0> 2020.03013792.10000061.092.10000092.100000NaN46.50000092.10000032.0930000.01140000.01.00.048.73333348.733333NaNNaN930000.01.140000e+061.00.039.17160517.072138NaNNaN22.700000930000.01140000.01.00.023.466667-0.500000NaNNaNENTIDADES EMPRESARIAISSERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESASVALE DO ACRERIO BRANCOATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES48.049.6350.37396.00.0NaNNaNNaNNaN2.01.01.00.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.00.0261.00.0261.07135.0135.0189.00.00.0135.01.01.02.01.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOACAC930000.0135.01.00.000000-28.5714290.00000019679112.019679112.0NaNNaN141536.0NaNNaNNaN6.0NaNNaNNaNNaN2.04.03.03.0
6NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOACONDOMINIO EDILICIOALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE1999-12-061185.57NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaN4.077.025.0099927213e8cf60291e8241bc78a1d92da8fbb2826ae30b45cad02dcc2ea19ba3.0NaN9.015.018.024.022.04.08.03.015 a 2018.906849NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN322.2000005027.166667NaNNaNNaNNaNNaNNaN93.83396278.721077NaNNaN3.933333NaNNaNNaNNaN3.933333-0.533333NaNNaNENTIDADES SEM FINS LUCRATIVOSSERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICASLESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES23.027.3672.64514.011.0NaNNaNNaNNaN15.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN408.024.0407.00106.0119.0199.0NaNNaN106.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN106.0NaN-10.924370-46.73366821.33333318700308.018700308.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
7110.933333NaN110.933333NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO POR ATACADOACIMA DE 1 ANOVERDE2004-12-241374.23210000.0210000.0TrueTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN4.021.017.0d85ce0e92df9ddc051b211f1a5e3d9f223d7efd4c992459acf257316ad43609c2.0NaN5.05.012.012.03.0NaN1.02.0> 2021.947945110.93333358.0110.933333110.933333NaN44.000000110.93333330.0210000.0210000.0NaNNaN212.933333212.933333NaNNaN210000.02.100000e+05NaNNaN78.92403139.840373NaNNaN3.933333210000.0210000.0NaNNaN3.933333-0.566667NaNNaNENTIDADES EMPRESARIAISCOMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETASNaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS24.035.7164.29161.07.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.01.01.00.00.00.0118.014.0118.0543.052.058.0NaNNaN57.01.01.04.01.01.01.0NaN4.00.0NaNNaNNaNNaNNaN2.0NaN1.0COMERCIORORO210000.042.0NaN-17.307692-25.86206930.10752710261987.013538405.0NaNNaN672056.0NaNNaNNaN6.0NaNNaNNaNNaN13.013.03.03.0
845.666667NaN45.666667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2004-04-24NaN210000.0210000.0FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseTrueNaNNaN14.064.016.0ccbfe46d5e42b751ffe2a742680e853f50ac12e9399c2ecc0538d68f5c1ed6b2NaN5.016.028.016.011.013.01.02.02.015 a 2019.61095945.66666745.045.66666745.666667NaN41.66666745.66666739.0210000.0210000.0NaNNaN170.300000170.300000NaNNaN210000.02.100000e+05NaNNaN48.91844024.691643NaNNaN2.166667210000.0210000.0NaNNaN2.166667-0.433333NaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTANaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS26.023.4076.60352.028.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0258.020.0258.0194.087.099.0NaNNaN94.01.01.03.01.01.02.0NaN3.00.0NaNNaNNaNNaNNaN3.0NaN1.0COMERCIORORO210000.094.0NaN8.045977-5.05050522.22222226067096.026277096.0NaNNaN217142.0NaNNaNNaNNaNNaNNaNNaNNaN11.011.05.05.0
9NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOAMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-10-14353.66NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN35.053.063.03aafa3a1f12f483740a52956af100223333d0e3c79bf2ce341896dd554e7229314.0NaNNaNNaN8.018.029.022.031.029.0> 2043.854795NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN506.9666675014.966667NaNNaNNaNNaNNaNNaN189.020309316.503220NaNNaN31.333333NaNNaNNaNNaN31.3333338.733333NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO NORTE PIAUIENSEVALENCA DO PIAUIADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.073.5126.49176.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN25.00.025.00151.0151.0151.0NaNNaN151.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaN151.0NaN0.0000000.0000000.00000024418584.024418584.0NaNNaN87223.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.02.02.0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
556NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO E REPARACAO DE VEICULOSACIMA DE 1 ANOVERDE2005-11-031660.52NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseTrueNaNNaN15.032.010.035bbd387f8a4cf454f781fbb75952f7efcadd9dabdfc6b5724fb110c96a74c374.01.03.08.08.05.04.09.013.02.0> 2040.720548NaN79.0NaNNaNNaN59.500000NaN40.0NaNNaNNaNNaN359.066667359.066667NaNNaNNaNNaNNaNNaN123.55614098.280351NaNNaN7.666667NaNNaNNaNNaN7.6666670.766667NaNNaNENTIDADES EMPRESARIAISCOMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETASOESTE POTIGUARMOSSOROCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS23.015.7984.2195.01.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN38.04.038.0257.060.063.0NaNNaN141.0NaNNaN2.0NaNNaN2.01.02.00.0NaNNaNNaNNaNNaN2.0NaNNaNCOMERCIORNRNNaN57.0NaN-5.000000-9.5238106.83760724212520.056646990.0NaNNaN100694.0NaNNaNNaNNaNNaNNaNNaNNaN4.016.01.01.0
557NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOACONDOMINIO EDILICIOALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE2007-02-081149.72NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrue1.0NaN16.060.028.01e36b2c6ecf8630e2f7c02cd759a81ad2e7acc8bf773b1aacf31c7daf3fac7113.01.011.022.019.021.014.05.07.02.010 a 1511.726027NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN442.266667442.266667NaNNaNNaNNaNNaNNaN76.50825450.578340NaNNaN2.200000NaNNaNNaNNaN2.200000-0.366667NaNNaNENTIDADES SEM FINS LUCRATIVOSSERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICASLESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES23.016.1983.81257.011.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN152.05.0152.00105.099.0119.0NaNNaN105.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN105.0NaN6.060606-11.7647064.90196121327624.021327624.0NaNNaN265726.0NaNNaNNaNNaNNaNNaNNaNNaN0.00.00.00.0
558634.300000NaN14.566667NaNDE R$ 500.000.000,01 A 1 BILHAO DE REAISDE R$ 500.000.000,01 A 1 BILHAO DE REAISBOASOCIEDADE ANONIMA ABERTAALTAELETRICIDADE E GASACIMA DE 1 ANOVERDE2005-11-031777.607.780736e+099.656361e+09FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseTrueNaNNaN64.0333.0372.0feb26abd3bfc64f12982f55a2368816d6ecb7e008965c2dc02a73dd75dada2bc35.08.046.0118.0144.0161.0108.037.052.060.0> 2052.035616634.30000065.0129.215196129.215196NaN55.50000014.56666741.01.999183e+092.629286e+09135.03907.0506.433333506.433333313031800.0572342800.01.144226e+081.420053e+088.861111383.071429139.020260166.4267373.307499e+075.637028e+072.733333164000.0210000.01.01.02.733333-0.066667185457.661819.2ENTIDADES EMPRESARIAISELETRICIDADE GAS E OUTRAS UTILIDADESLESTE POTIGUARNATALELETRICIDADE E GAS24.024.7175.291421.051.0NaNNaNNaNNaN65.068.068.00.00.00.00.00.00.068.00.00.00.02.00.00.00.048.00.068.00.00.06.00.00.056.018.062.00.00.0651.090.0649.029770.0815.0857.03986.010726.0788.014.02.013.0164.02.08.09.011.02.02.00.00.00.00.010.0NaN6.0INDUSTRIARNRN7.780736e+09769.0319.0-5.521472-10.15169211.399620500805000.0516073630.07.937997e+081.578368e+099215811.022.66119121.8603721.059548NaNNaNNaNNaNNaN167.0168.016.016.0
559481.033333NaN99.566667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2005-08-273071.988.209219e+069.349219e+06FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseTrueNaNNaN2.064.03.06c0463d509136d232f05962554b6c3e94c04c1627ad9a3441548441e3aee97ed1.01.03.015.011.014.07.07.08.02.0> 2042.723288481.03333371.0264.744444264.744444NaN49.66666799.56666737.07.789219e+068.719219e+061.048.0444.3000005064.7000002596406.52596406.52.736406e+063.116406e+061.00000024.00000096.74975837.1787952.596406e+062.596406e+067.166667210000.0210000.01.00.07.166667-0.7333332596406.52596406.5ENTIDADES EMPRESARIAISCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS24.059.4240.58449.02.0NaNNaNNaNNaN1.03.03.00.00.00.00.00.00.03.00.00.00.02.00.00.00.00.00.03.00.00.00.03.00.00.01.00.00.00.0380.07.0380.0969.075.099.048.048.0117.03.01.03.03.01.02.0NaN3.00.0NaNNaNNaNNaNNaN3.0NaN1.0COMERCIOAMAM8.209219e+0669.02.0-8.000000-30.3030309.79021021018528.029660482.02.596406e+062.596406e+06294723.0NaNNaNNaNNaNNaNNaNNaNNaN6.06.01.01.0
56056.200000NaN56.200000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2006-02-01NaN9.300000e+059.300000e+05FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN150.0127.02.0f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de5891b7bafbd7fe7cfc34.0NaN6.021.026.045.041.043.044.019.010 a 1512.74520556.20000049.056.20000056.200000NaN41.00000056.20000033.09.300000e+059.300000e+05NaNNaN5099.0666675099.066667NaNNaN9.300000e+059.300000e+05NaNNaN173.80967761.097177NaNNaN20.733333930000.0930000.0NaNNaN24.700000-0.566667NaNNaNENTIDADES EMPRESARIAISSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICASCENTRO AMAZONENSEMANAUSATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.063.4436.56981.00.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0702.08.0702.00279.0287.0296.0NaNNaN279.01.01.02.01.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOAMAM9.300000e+05279.0NaN-2.787456-5.7432432.82685540955220.040955220.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
561596.233333NaN16.700000NaNDE R$ 300.000.000,01 A R$ 500.000.000,00DE R$ 500.000.000,01 A 1 BILHAO DE REAISBOASOCIEDADE ANONIMA FECHADAALTAINDUSTRIA DIGITALACIMA DE 1 ANOVERDE2008-01-145985.495.223031e+095.451955e+09FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMTrueFalseFalseFalseTrueFalseNaNNaN140.02447.0563.0251f454db948590c50df496ea83f76e2227e24a32c2814dd00b363fd77754e295.07.0643.0949.0749.0444.0200.095.041.017.010 a 1510.794521596.23333372.0106.631111106.631111NaN52.50000016.70000035.05.150974e+095.372531e+09275.01716.030.333333146.600000171568880.0241816100.03.482021e+083.634637e+0824.000000361.60000023.34154118.2843453.669588e+075.131406e+073.433333210000.0210000.01.010.03.433333-0.466667288489.6288489.6ENTIDADES EMPRESARIAISATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAONORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISINFORMACAO E COMUNICACAO23.033.5666.445340.0465.0NaNNaNNaNNaNNaN15.015.01.00.00.00.00.00.015.00.00.08.01.00.00.00.010.00.015.00.00.04.01.00.010.03.02.00.00.02168.0394.02162.063172.03186.03460.01229.01808.03787.07.04.05.028.0NaN4.0NaN5.00.0NaNNaNNaNNaNNaN4.0NaN5.0SERVIÇOMAMA5.223031e+093150.0288.0-0.439422-8.32369912.561773459934850.0560530400.01.834794e+082.565703e+08NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
56258.266667NaN58.266667NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO POR ATACADOACIMA DE 1 ANOVERDE2003-04-02NaN3.770971e+063.770971e+06FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseTrueNaNNaN14.0149.05.0fab2fcabc509768ba2943a21e674fb5af79cb3498730483083054afbb4647cc57.05.013.019.021.035.029.017.012.010.015 a 2015.58356258.26666753.058.26666758.266667NaN53.00000058.26666753.03.770971e+063.770971e+06NaN21.0182.433333182.4333331256990.41256990.43.770971e+063.770971e+06NaN21.00000050.48333324.6749311.256990e+061.256990e+062.2333333770971.23770971.2NaN21.02.233333-0.6666671256990.41256990.4ENTIDADES EMPRESARIAISCOMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETASCENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS23.013.6986.31606.044.0NaNNaNNaNNaN1.01.01.00.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.00.0436.042.0436.00170.0173.0177.021.021.0168.01.01.02.01.0NaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaN1.0COMERCIOAMAM3.770971e+06168.0NaN-1.734104-3.95480224.85207153164510.053164510.01.256990e+061.256990e+06NaNNaNNaNNaNNaNNaNNaNNaNNaN0.00.018.018.0
563536.733333NaN346.366667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTABENS DE CONSUMOACIMA DE 1 ANOAZUL2005-11-03814.858.281920e+051.248192e+06FalseTrueFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseTrueTrueNaNNaN14.0104.09.0564fde999c34d33a262dad0e1596029b2b5f92e4f0aed68dc1e8d47020bf9c615.01.010.023.027.015.017.014.05.010.0> 2023.698630536.73333360.0441.550000441.550000NaN58.500000346.36666757.06.181920e+058.281920e+051.04.0443.033333443.033333247276.8247276.84.140960e+056.240960e+051.0000004.00000087.90210051.2026562.472768e+052.472768e+052.266667210000.0420000.01.04.02.266667-0.433333247276.8247276.8ENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS ALIMENTICIOSLESTE POTIGUARNATALINDUSTRIAS DE TRANSFORMACAO23.022.8377.17365.034.0NaNNaNNaNNaNNaN2.02.00.00.00.00.00.00.02.00.00.00.01.00.00.00.01.00.02.00.00.02.00.00.00.00.00.00.00.0238.019.0237.00127.0112.0153.04.04.0127.02.01.02.02.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0INDUSTRIARNRN8.281920e+05127.02.013.392857-16.99346415.89958227658940.027658940.02.472768e+052.472768e+0572226.0NaNNaNNaNNaNNaNNaNNaNNaN2.02.02.02.0
564NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNSERVICO SOCIAL AUTONOMOALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2000-04-032323.03NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN3.016.073.031438f752b4a846638c0acd98c3078d7e1ee83204e0388bb15a61f38b358216c2.0NaN1.08.018.017.019.016.05.06.015 a 2018.580822NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN300.466667373.766667NaNNaNNaNNaNNaNNaN69.31123254.917612NaNNaN2.066667NaNNaNNaNNaN2.066667-0.433333NaNNaNENTIDADES SEM FINS LUCRATIVOSEDUCACAONaNNaNEDUCACAO23.059.7840.22388.05.0NaNNaNNaNNaN4.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN296.030.0296.01092.0118.0132.0NaNNaN482.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORORONaN92.0NaN-22.033898-30.30303028.70813426530740.0108877850.0NaNNaN1603418.0NaNNaNNaNNaNNaNNaNNaNNaN17.019.02.02.0
565323.066667NaN74.166667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2005-11-034315.606.189792e+066.609792e+06FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrue1.0NaN69.065.02.08a226339b331b5aec24877a69edc40070b9dd7e71b21943996db577948efaf694.0NaN14.020.023.020.022.011.014.09.0> 2041.164384323.06666768.0191.375000191.375000NaN66.50000074.16666765.05.563728e+065.773728e+061.045.0258.033333258.0333332781864.02781864.01.547448e+061.652448e+061.00000012.00000036.16861311.3359411.442448e+061.442448e+064.866667206064.0210000.01.00.04.866667-5.566667103032.0103032.0ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSCENTRO NORTE PIAUIENSETERESINACONSTRUCAO23.05.1194.891844.014.0NaNNaNNaNNaN2.04.04.00.00.00.00.00.00.04.00.02.00.00.00.00.00.00.00.04.00.00.04.00.00.00.02.00.00.00.01707.05.01706.06137.0128.0511.048.048.0137.03.01.02.04.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN2.0CONSTRUÇÃO CIVILPIPI6.189792e+06137.02.07.031250-73.1898243.77358519782144.022572144.02.884896e+062.884896e+06100470.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.00.00.0